Hello everyone,

Anyone know vba (excel) that will let me:

1. go to the last cell in the worksheet
2. select that cell
3. delete everything in the cell
4. then select that cell and everything else if A9 is blank
5. delete the selection
6. SUBTOTAL the last row

--
This might seem a little confusing, but let me know if I need to be more
specific.

** Any help will be greatly appreciated.

Have a good day.
--
Himansu