Using Function in VBA

**Jiptastic** · 12-09-2012, 05:25 PM

Any ideas where I'm going wrong here? I'm trying to define my variable as the column number where the header is "Results". Then I want it to tell me the value so that I know it works before I proceed. It displays the following error message "Unable to Get the Match Property of the worksheet function class".

Please Login or Register  to view this content.

**shg** · 12-09-2012, 05:41 PM

Please Login or Register  to view this content.

**mrice** · 12-09-2012, 05:46 PM

Suggest this alternative

Please Login or Register  to view this content.

**Bishonen** · 12-09-2012, 05:48 PM

Just a question: why would one declare result as long? thanks

**Jiptastic** · 12-09-2012, 06:14 PM

Great! I have lots of things to try. I have the same question as Bishonen. I thought that long was used only if you wanted a vary large number range, but I could be wrong.

**shg** · 12-09-2012, 08:17 PM

Longs calculate at least as fast as Integers in VBA, and row indices must be Longs. I never use integers (small i) smaller than Longs unless they are large arrays.