Joe, what is often done, is use an extra hidden worksheet (xlHidden or
xlVeruHidden) where you store some data.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Joe HM" wrote:

Hello -

I have restriced inserting and deleting rows on a Worksheet to make
users use functionality of a custom toolbar. That way I can make sure
that formatting stays consistent.

I am now trying to make an undo function after the deletion of a row.
Currently I store the .Value and other . entries in global variables
but it seems like there should be an esier way.

I tried to define a ...
Public mRange as Range
and then assign ...
Set mRange = lSheet.Range(...)
.... but when I try to access mRange from within another function, it
seems to have lost all the data.

How can I create a copy of the range and store it in a variable in
order to restore it later on?

Thanks,
Joe