Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
vlookup in vba code
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Walt, post: 6065716"] Hi sharonm, If your activecell is in any column less than 32(AF), you would get that error, since you are referenceing a cell 31 columns to the left of the activecell. Also, try: Set rng = thisworkbook.worksheets("TLA").Range("A2:D15") ActiveCell.Value = _ Application.WorksheetFunction. _ VLookup(ActiveCell.Offset(0, -31).Value, rng, 3, False) Best Regards, Walt Weber [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
vlookup in vba code
Top
