Giving HyperLinks in Workbook

**theprincesunil** · 07-19-2012, 04:43 PM

The below provided VBA Code is working fine. Still, I want to know few things.
1. Why we have used H
2. I did not use any Dim statements. still code is working.

Could some one please tell me what makes this code working properly

Please Login or Register  to view this content.

Thanks in Advance

**Leith Ross** · 07-19-2012, 04:56 PM

Hello theprincesunil ,

It looks like the author of the macro used "H" to indicate the Hyperlink's row.

Unless you have "Option Explicit" at the top of a Standard VBA module, VBA will not force you to declare the variables and their types. If you do not use the Dim statement the variable is typed as a Variant by default.

**Pete_UK** · 07-19-2012, 04:57 PM

H is a counter that gets incremented from 1 up to the number of worksheets that you have. It is used a few times within Cells(... , and as such it controls the row where the hyperlink is written to.

Although you should declare the variables and specify the type, if you don't do so then Excel will treat them as type Variant (which use up more memory than Long, which could have been used in this case).

Hope this helps.

Pete

**TMS** · 07-19-2012, 04:58 PM

H is just a variable which allows you to determine which row to put your headings. In this case, they are going in row 1.

You don't have to Dim variables, although it is good practice to do so ... both from an efficiency point of view and to avoid typing errors when you actually use variables. If you use Option Explicit, you are forced to Dim all variables or the code will not compile.

A variable will take whatever data you want to put in it but, if you expect text, you should define it as String. If it's numeric, it can be Integer, Long, Double, etc. I usually define variables relating to row numbers as long but, in this case, Integer would be fine ... it's just a counter ... assuming there won't be a great number of rows.

Hope that provides the clarification you were seeking.

Regards, TMS