LinkBack URL
About LinkBacks
Hi,
I'm trying to create the below lookup in VBA using a variable as the datasheet to lookup to. I get an error of "Object does not support this Property or Method" any ideas why
Please Login or Register to view this content.
Hi,
I'm trying to create the below lookup in VBA using a variable as the datasheet to lookup to. I get an error of "Object does not support this Property or Method" any ideas why
Please Login or Register to view this content.
why do you call it a sheet when its a workbook? that is confusing.Please Login or Register to view this content.
at a guess you need to make it the string(name) in the formula not a sheet object
also you need and = sign
Please Login or Register to view this content.
Last edited by scottiex; 10-07-2017 at 06:57 PM.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
In the line that sets the formula use
Formula:
Please Login or Register to view this content.
and don't forget the = sign
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
good point re sheet
adding the equals sign doesn't make a difference. I still get the same error
Perfect Thanks Richard
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks