If you "cleared" instead of deleting, delete and then SAVE. Try it.

--
Don Guillett
SalesAid Software

"DeanT" wrote in message
...
Is there a macro command to rest the worksheet region/range after deleting
several rows.

After I delete and then go to last cell or current region, it still shows
the area before the delete.

Thanks for your help.