vlookup in VB

[Sarah K]

Hi there.

I'm trying to do a vlookup in Vb, I've come up with the following but it's not working (and it's not because I haven't defined the variables or anything, i just don't know the correct code for the vlookup in vb (it's clear as crystal when I'm doing one in a cell in the excel worksheet!)).
Using excel 2002.

application.vlookup(range(cells(i,2)),windows(x).sheets.range(E:H),2,false)

thanking you

 

[Greg Truby]

Last I checked, winders didn't have no sheets fer chillens. Sheets' parents are workbooks. And yer gonna need to put that "E:H" bit inside some quotation marks.

 

[joy_666]

Hey,

Have you tried to record the vlookup in a macro????

It helps.....

 

[Sarah K]

Hi
I tried recording a macro, but that puts the vlookup in a cell and I want it to live in vb.
Any suggestions?

 

[joy_666]

Hey,

You want the code to be pasted until the last row of some defined column...

Is that your requirement?????

 

[Greg Truby]

Hey,

You want the code to be pasted until the last row of some defined column...

Is that your requirement?????

I believe she wants to execute a VLookup in code itself. Just like I showed a guy on another forum yesterday.

 

[Sarah K]

Hi
Yes, I'm going to have to do this lots, so want the most efficient code possible. I will have a column of values in one workbook and I will need to do the vlookup for each of the column entries in a different workbook. Do vlookups actually exist in VB??

 

[Greg Truby]

Any suggestions?

Um, yeah. Try applying the information I already provided - correct the parent and the syntax. :wink:

 

[Sarah K]

Greg,
you've got the idea of what I want...can you use my example and show me how to look up the cell value in a completely different workbook?
Thanks a million!

 

[Sarah K]

Like this:
application.vlookup(range(cells(i,2)),workbook(x).sheets.range("E:H"),2,false)
??
Says I have a 'Compile error: expected: =
I like your parents/children thing