having hopefully small issue with a lookup formula/function in vba

[hopefulhart]

hello,

i have been using a lookup code such as

Please Login or Register  to view this content.

as part of a larger module and it has been working exactly how i expected

i want to modify it a bit so that the "{0,0.5}" part is a changing variable depending on other code
ie:

Please Login or Register  to view this content.

however i got an error message when i got to that line of code.
i was wondering if i need to dim x as something in particular for vba to recognize it, i have it as

Please Login or Register  to view this content.

or maybe there is another issue that im missing

thanks for any thoughts on this one


well i figured out a solution right after i posted!!

Please Login or Register  to view this content.

seems to work, may not be the best way but it works

[Bernie Deitrick]

Just so you know, the way to do that in VBA is along these lines:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.