Printing spreadsheets macro
Hi All,
I currently print forms which i want a macro for. However the table size in the form varies. Sometimes it is 3 coulmns and 2 rows, sometimes 7 coluimns and 20 rows (which goes over 2 pages).
Is there a way the macro button can say ' if 7 columns & 15 rows' print on 2 pages wide.
If '<3 columns' print on 1 page.
Any help here would be great.
Toms
|