Marking page end

  • Thread starter Thread starter lucy
  • Start date Start date
L

lucy

how do i mark the last used cell as page end, my spreadsheet goes down to row
26661 and across to BU. We are currently only up to line 3660 row Z
 
how do i mark the last used cell as page end, my spreadsheet goes down to row
26661 and across to BU. We are currently only up to line 3660 row Z
Click to expand...

What are you looking for? You can probably set the PrintArea
dynamically if you want easy printing. Or if you want the last cell
automatically highlighted or Named (so you can find it easily) in some
way, a macro or UDF can do it. You could also set the PrintArea
manually pretty fast if you know the shortcuts to manuvering around a
spreadsheet.
 
Back
Top