print only data and no empty cells

HI
I need to print the data in a spreadsheet.
Printing should be done only where data contains.

But this spreadsheet may have more data (now it has data to lines 39)

Hi marreco. press CTRL + F3 & you should see an existing Name "Print Area". click on the name & then click on the formula in "Refers to". use this formula instead:
=OFFSET($B$3,,,COUNTA($B:$B),5)

hi
you can do this automatically using VBA?

Thak you!!

not sure why you need it in VBA since it's a one time setup that changes dynamically whenever you increase or decrease rows. but here's a code anyway:

Please Login or Register  to view this content.

hope that helps

Hi.

it was very good!

Thank you very much!