After deleting the data you have to save the workbook to reset.
--
Mike Q.


" wrote:

I've written a macro that copies/pastes a lot of data from different
files into a single sheet. My macro pastes the data using a LastRow
variable I included based on the ActiveRange.

My problem is when I try to delete the data and run it again, the
ActiveRange is not resetting - it is registering the End at wherever my
data previously ended. I try clearing the contents, setting formatting
to general, but nothing seems to work. Does anyone know how to fix
this?

Thanks,

Brad