Prints blank page after data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dawn - 03 Dec 2003 17:37 GMT

I have a worksheet that always prints a blank page after the data is
printed.

I have deleted several hundred rows below the data with no effect. I have
checked that there is no formatting, hidden formulas, or anything else
contained in any cell beyond the last row of data.

In the VBA editor, the line ActiveSheet.UsedRange.Select consistenly selects
to the 2500th row, no matter how many times I delete (not clear) the rows
between the end of my data and row 2500.

This form is filled in by a macro, and may end up being 1 page or 50, so I
can't set a print area except by calculating it in the macro.

Any suggestions?

Thank you.

Reply to this Message

Paul B - 03 Dec 2003 20:08 GMT

Dawn, where does it take you when you do Ctrl+end? this is where excel
"thinks" the last cell is, you could delete ALL the rows and columns after
your data and see what happens, if that fixes it then run the macro and see
if it happens again, if so there is something in the macro doing it. You
could also run this code before you print to reset the last cell, I think
that will do it

Sub Reset_Last_Cell()
x = ActiveSheet.UsedRange.Rows.Count
ActiveCell.SpecialCells(xlLastCell).Select
End Sub

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

> I have a worksheet that always prints a blank page after the data is
> printed.
[quoted text clipped - 13 lines]
>
> Thank you.

Reply to this Message

Gord Dibben - 04 Dec 2003 00:41 GMT

Dawn

After deleting(not clearing) the rows make sure you save the workbook.

In some versions a save/close/reopen is necessary to reset the used range.

Gord Dibben XL2002

>I have a worksheet that always prints a blank page after the data is
>printed.
[quoted text clipped - 13 lines]
>
>Thank you.

Reply to this Message

Rate this thread: