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

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

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused

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

--

Dave Peterson