LinkBack URL
About LinkBacks
I need help with syntax of the following code. What I trying do is Search sheet label “MRP” in Column A to find the value on Sheet ("Pay").Range("B1").Value. It doesn’t like the last line.
Please Login or Register to view this content.
I need help with syntax of the following code. What I trying do is Search sheet label “MRP” in Column A to find the value on Sheet ("Pay").Range("B1").Value. It doesn’t like the last line.
Please Login or Register to view this content.
Last edited by ca1358; 07-06-2011 at 06:30 PM.
Usually better if you post a sample workbook.
However, try something like this:
Please Login or Register to view this content.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I am getting runtime error 91
Object variable or with block variable not set on this line
MsgBox fndRng.Address
Probably means it can't find whatever is in cell B1 on the Pay worksheet.
Post the workbook you're using to test it.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks