I am wondering how I can manage to select all visible sheets in my workbook, with MULTIPLE exceptions, and then paste the selected range into one workbook with always one free row after each pasted sheet.
here my code, hope someone has a sparking idea
Eg. I want to select all visible sheet except sheet "Summary", as posted above, but as well another sheet called "Report".![]()
Please Login or Register to view this content.
Then, I would need to select cells A2:H200 on all remaining sheets, and once sucessfully copied, paste it onto sheet "Report", but I do not know how to make excel understand to insert a blank row first...
Thanks,
A2k
Bookmarks