You are best off to not move the active cell around at all. You can do
everything that you need with range objects. Post your code and let us take a
look at it. Essentially we can help you remove the .selects and to declare
and manipulate range objects to do what you need. It will make the code
shorter and faster, with more options.

--
HTH...

Jim Thomlinson


"RAP" wrote:

Hello, Folks
I have a problem that I simply can't work out for myself. I need some
ideas, please.
On page 1, I need to copy the address of a cell to a variable. I can do
this and have it show up in a MsgBox. I need to perform other calculations,
cut, paste, etc..,
on the same sheet as well as on another sheet.
At some point, I need to return to sheet 1 and call the variable to make it
the active cell again.
Any help would be much appreciated. Thanks
Randy