Hello.

I need to reset the range used by a macro to nothing each time i run it so i use the following code:

Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Cells.Delete
Selection.EntireRow.Delete
Worksheets("Sheet1").ReSetUsedRange
Something is not working because when i manually press Ctrl+Shift+End after running the above code the selected area is still the one previously used. How can i reset it to nothing?

Thanks a bunch for any helps.

Octavio