jamesblack90
New Member
- Joined
- Jun 9, 2015
- Messages
- 44
[SOLVED]
Sorry I don't know how to delete a thread.
I just noticed what I did wrong
Sorry I don't know how to delete a thread.
I just noticed what I did wrong
Last edited:
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Using a defined range variable in vlookup
- Thread starter jamesblack90
- Start date
RoryA
MrExcel MVP, Moderator
- Joined
- May 2, 2008
- Messages
- 41,105
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Remove the '.' before rngDuties. It's a range variable which refers to a range on a specific sheet. The variable itself does not need to (and cannot) be qualified with a worksheet object. (i.e. do what you did in the line above )
)
Upvote
0
