Hello,
I have a worksheet with a data Range(A1:F240) which spans across 3 Legal size pages.
I programmed a macro to automatically hide empty rows across the range.
The last 24 rows are always visible.
What I'm trying to do now is print exactly what I see (only the visible rows) on 1 or 2 pages, without blanks.
I figured I would, through a VBA macro, copy-paste the visibles cells to a scratch worksheet and then print that sheet.
Unfortunately, this code just carbon-copies the source worksheet INCLUDING hidden cells: My data still spans over the same 3 print areas, and my last 24 rows still print on the bottom of the 3rd page.
Please help
Thank you
Bookmarks