Print until last used row in a range

[MariaPap]

Hi there

I have a sheet with reports getting using an advanced filter.

What i would like is a macro that will print all the data that exist in columns A:E, UNTIL the last used cell of column A.

Thank you in advance for any suggestion.

[alansidman]

Try this:

Please Login or Register  to view this content.

[MariaPap]

Thank you Alan. Works perfectly.

May i ask for something else if it's possible?

Is possible to the last row of eatch printed page to count the number of the page and print it?

Something like --Page 1-- , --Page2-- etc....?

[alansidman]

Why not set it up in your layout so that it prints in the footer.

http://office.microsoft.com/en-us/ex...010269060.aspx

[MariaPap]

Apologize for the delay in my reply. We had Nnternet conection problem.

Alan Thank you. It's easy when you know how to do this!