View Single Post
  #1   Report Post  
GarToms GarToms is offline
Member
 
Posts: 33
Default 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