Printing variable number of rows

[JRM]

How do I write a macro to print a variable number of rows from a spreadsheet?
eg the data in todays sheet may be only 30 rows, tomorrow it may be 300 rows - or any number in between.

Currently I have it set to print the maximum number (using Print Area) irrespective of whether they have any data in them or not & its simply a waste of time,paper & ink.

thanks
john

[Leith Ross]

How do I write a macro to print a variable number of rows from a spreadsheet?
eg the data in todays sheet may be only 30 rows, tomorrow it may be 300 rows - or any number in between.

Currently I have it set to print the maximum number (using Print Area) irrespective of whether they have any data in them or not & its simply a waste of time,paper & ink.

thanks
john

Hello John,

You almost have your problem solved. You can access Excel worksheet functions through VBA. One function COUNTA can be used to find the number of none empty Rows or Columns on a worksheet. Use this to select the Range and then set Print Area to this Range.


Hope this helps,
Leith Ross

[JRM]

Hi Leith

I can see what you're getting at and now understand COUNTA but please can you help me with the syntax of incorporating this into SET PRINTAREA.

eg I want to print out A1:D60 today and A1 to D100 tomorrow depending on the amount of data.

thanks

John
ps I'm a relative novice at macros !