I have been using the same workbook for months, now all of a sudden the macro has stopped working. The code I am using is
When I run the macro now it is giving me a Type Mismatch error. Please help!Please Login or Register to view this content.
I have been using the same workbook for months, now all of a sudden the macro has stopped working. The code I am using is
When I run the macro now it is giving me a Type Mismatch error. Please help!Please Login or Register to view this content.
Last edited by shg; 07-09-2011 at 01:08 AM. Reason: fix closing code tag
you probably changed the macro without you notice it. You are applying the offset to the sheet index instead of the range. See corrected macro below.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks