This is what I did: I opened up VBA editor; copied and pasted your code. Then I had to enable macros, and then I clicked on 'Run" and got an error message:
Compile error: Invalid outside procedure.
Would it make any difference that it is tab 7 in a workbook? I can see that 'Sheet 7' is highlighted on the sidebar.
Thank you.
Hi,
The macro should be run with the sheet containing the data is the active sheet. It could be changed to refer to a specific sheet.
Is your real data EXACTLY the same layout as your example on which the macro is based?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard,
Yes it is. I cut and pasted from the original. Would this forum allow me to send the entire sheet to you to see?
Thanks,
Eva
Hell Eva,
You don't need to send the entire workbook if it's very large. Just delete most of the rows but leave a good representative sample and upload.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks