Hello.
I need to reset the range used by a macro to nothing each time i run it so i use the following code:
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?Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Cells.Delete Selection.EntireRow.Delete Worksheets("Sheet1").ReSetUsedRange
Thanks a bunch for any helps.
Octavio
Bookmarks