Hi!
I found the below code in this forum to compare the content of two worksheets within the same workbook. In fact, the code is working pretty good. However, when the code does not find any differences, I have an "out of range". Any idea, how to fix this with a pop-up "Nothing found"? Thanks in advance!
Please Login or Register to view this content.
Last edited by FixandFoxi; 06-18-2012 at 09:47 AM.
Can you attach the sample file that you are using with the code?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi & thanks for your reply! Please find attached the file. The workbook has two sheets. As you will note, there is a difference in cell B6 (the age is missing in the second sheet). When you now perform the macro, the code will drop you this difference. However, as soon as the sheets are equal (e.g. add 96 in the second sheet), I have the "out of range".
Your code is giving at error on this lineBut i dont have much experience with arrays. Let us see if you get some help from others here or i can push it to the experts.Please Login or Register to view this content.
After Line47 I added:
The code is now working when NO/NIL differences are found.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks