MrExcel Publishing
Your One Stop for Excel Tips & Solutions

delete old used rows


Posted by Andonny on May 16, 2001 1:54 AM

Hi,
I would like to make all cells or rows below my last cell used as never been touched before with a macro. I sometimes have problems printing. It thinks there are hundreds of pages.

I was wondering if there is another way to post a message on this board. It takes about ten minutes to get to the bottom of the page at the moment. Its a great site and I am just looking for a solution.

Thank you for your help
Andonny


Posted by Dave Hawley on May 16, 2001 5:26 AM


Hi Andonny

Regarding the Slow download of this page you could contact Bill (Mr.Excel) on
consult@MrExcel.com
You might even want to suggest placing the Question button at the top. This would be better for him as well(less archiving)


For the clearing of those not really empty cells, try this code:


Sub GoAwayBlanks()
Range(Cells.Find(What:="*", After:=[A1], _
SearchDirection:=xlPrevious).Range("A2"), Range("IV65536")).Clear
End Sub
OzGrid Business Applications