VB Formula

[Dennis]

I have two spreadsheets, where the name of one of the
spreadsheets is a variable in visual basic.

i.e. let X = Spreadsheet A

I want to do a vlookup to that spreadsheet in visual
basic, but it seems like excel takes the vlookup formula
vlookup(A1,X!A,4,false) to mean look at the worksheet X
(not the spreadsheet A)

anyone know how to get this to work?

Thanks

-Dennis

 

[Harald Staff]

Hi Dennis

What kind of Visual Basic and where doing what ? Where does this formula go
and how (VB doesn't do VLOOKUP) ? Where is the variable X ? "let X =
Spreadsheet A" will err, do you have any real code that works (or tries to)
to show us ?

Sorry bout the nagging, the information is really necessary.

Best wishes Harald