Reset used range to nothing

Hello.

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

Please Login or Register  to view this content.

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

Hello Palmetto.

Hmm. It's not working...
I entered your code like this:

Please Login or Register  to view this content.

I'm wondering if it is not the correct way...
I'm pulling my hair for hours and hours. The code i wrote enters subtotals on a list and works fine except for the Grand Total which does not appear in the last row but in a few hundreds of rows bellow, like there was data between the last row of the list and the Grand Total line. Arrrrrgggggg!!

Thanks anyway. I'll keep on trying.

Octavio