Something along the line of

With Activesheet
.Range("101:65536").EntireRow.Delete
.Range("M:IV").EntireColumn.Delete
.UsedRange
End With

Might work. Adjust to match your situation.

--
Regards,
Tom Ogilvy



"Posse John" wrote in message
...
I import data from an external source into a workbook. Thru a macro, I
sift
thru the information and delete unwanted entries. I start out with 1900
rows
of info, after deleting unwanted information, I am left with 100 rows.

After deleting the information, how do I 'reset' Excel to put me at the
last
row used (by the good data) when I press CTRL+End?

When I press CTRL+End now, it takes me to the last row/column that ALL the
data used.

I tried setting by using ActiveWorkbook.Saved = True, but this did not
alleviate the problem.

I do not want to save the workbook, then reopen it.