LinkBack URL
About LinkBacks
Hi, is there any reason that the following code should not work:
I'm kind of stumped on what could be the issue.
Please Login or Register to view this content.
Thanks
Hi, is there any reason that the following code should not work:
I'm kind of stumped on what could be the issue.Please Login or Register to view this content.
Thanks
Your VLOOKUP range is in a single column C12:C13 but you are telling VLOOKUP to retrieve the answer from the second column. This probably results in a runtime error, or a #VALUE! error in the worksheet.
What are you seeing that is different than what you expected?
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
why not just use a regular vlookup, and not even bother with VBA?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Y'know, that is an excellent point. Both sides of your assignment are constants. Can't imagine why this needs to be done in VBA.Originally Posted by FDibbins
Thanks Jeff, not being VBA savy, I am always looking for formula way
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks