Hello,
I have copied a worksheet within a workbook several times.
The worksheet had a range named "MyRange"; As I copied the worksheets within the workbook, I ended up with multiple ranges with the name "MyRange".
I need a macro which could count how many times the "MyRange" appears in the workbook and display it in a message box along with the corresponding worksheet names.
Please advise.
Thanks !
Hi plans,
Try this:
Regards,
Please Login or Register to view this content.
Robert
Last edited by Trebor76; 12-07-2018 at 10:12 PM.
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks