Hi, Hoping I can find some help here.
Tried to keep the title as descriptive as possible.

I have a sheet that uses eg: Blocks A1:X10,A12:X22 etc to hold data/text etc.

I am filling colums A to V with data and Ranking and summing them in W & X,
I don't need to show K, L M ...for example, until they are totally filled, so I hide them manually until needed.

Have a Macro to print "results" A1:X10,A12:X22 etc, and I set a "print area" or "print selected"...works fine to fit to 1x1 Page.

Problem: If I hide L, M, N etc, the macro runs fine but still uses the unhidden size of the selection to fit the page ie: I get A-B-C-D...-W-X as required, but the other half of the page is blank, because the size selected is for all.

Q: How can I (Simply) print what's visable to 1x1 Page, fitting more in each time I unhide a column or two.?

Make sense? Thanks in advance (Great Forum BTW)