HLOOKUP & VLOOKUP 1

[airon]

This is probably pretty simple, but I am having some trouble figurit out.

I am trying to do some lookups in some Excel spreadsheets.
Is there a way to use HLOOKUP in VBA, I can do it in the actual spreadsheet, but I am running in to problems when I try to do it in VBA.

Aaron

example:
HLOOKUP("Axles", A1:C4,2,TRUE) VBA does not like ":"

 

[DarkSun]

You need to use something like this:

Worksheetfunction.HLookup("Axles",sheets("NameofSheet&quot.Range("A1:C4&quot,2,true)

if you look at Worksheetfunction you will see that it has all the functions you can use in a excel.

 

[airon]

Thanks for taking a minute and helping with my problem, it was very helpful.

Airon