Can someone help me figure out what is wrong with this? I am getting Error 2042.
Please Login or Register to view this content.
Can someone help me figure out what is wrong with this? I am getting Error 2042.
Please Login or Register to view this content.
See if this helps
Please Login or Register to view this content.
Last edited by mlcb; 01-05-2015 at 12:01 AM.
Marcelo Branco
I still get 0 or error 2042.
The Straight reason for getting the 2042 error is that the Match Function is not finding the match resulting to #NA (Equivalent to Error 2042).
Try using
with Marcelo Branco's Suggestion that is using .Rows(6) instead of Row(6)Please Login or Register to view this content.
Use F8 to test the code step by step. U can check the return value of Ro and Col by putting ur cursor on these variables.
and share your results here, if don't get sorted.
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks