Hi Excel Forum,
I have a Workbook1 which contains multiple hidden rows & multiple hidden columns. I currently have a code to copy my specified range to Workbook2, but so far I can only either copy everything (i.e. all hidden/non-hidden) or just visible. The problem is that I only want to copy visible rows while still copying all the hidden columns.
Here is my code so far, which copy/pastes everything in the range. (Please note the top half of the code is not relevant, but I kept it here to avoid misunderstanding.)
Thanks for any tips/advice/help!
Bookmarks