Record Selection
 

Hi Everybody

I am stuck on what am sure is a simple problem but I just cant see the answer
My user will select a range of cells, I want to record this selection and
re-activate it later. How can I do this?

Many Thanks

Record Selection
 

Possibly use the selectionchange event to store the range selected. The
selection will be contained in the target argument.

See Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"PraxisPete" wrote in message
...
Hi Everybody

I am stuck on what am sure is a simple problem but I just can't see the
answer
My user will select a range of cells, I want to record this selection and
re-activate it later. How can I do this?

Many Thanks