Find print area

G

Guest

I have a data set with varying range. The maximum column limits are A and AB.
There is no upper limit for number of rows but data set starts from the 23rd
row. I want a macro to find the last nonempty row and column and return their
position. So in the end it would choose this area as a "Print_Area".
For example: If the last filled column is Z and the last filled row is 2876,
I want the macro to return Z2876. So I would set A23:Z2876 as the print area.

Please help meee!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Area 4
Print Area to include text box 10
auto scale print area 3
Another Print Area question 3
How can I expand print area to whole page? 8
email as pdf print area excel 2007 1
Print Area to last cell with data 7
VBA to set dynamic print area 1

Top