Hi,
I am working on XL database and have two codes for pulling data out from the main sheet on to sheet2 and another code to put it back after I update info.
The 'replace' code seems to be having problem and keep giving me "match not found for row 2" message.
Appreciate your help on this. Here is the code:
Thank you.
Please Login or Register to view this content.
Last edited by VBA Noob; 01-28-2008 at 04:02 PM.
Hello jazbeth,
If all the other rows are OK then I have to ask did you check the values when you get the error message? It could be there is no match.
Sincerely,
Leith Ross
Hi Leith,
thank you for responding. The error message is only "match not found for row no." it would give you row number.
Thanks
Jaz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks