Cell Address

[Ritt]

Help Please on this. It should be easy to most of you. I put the activecell.address in a variable named X moved on and would know like to activate that cell again using the X variable. How can I call the address back and activate the cell?

X = ActiveCell.Address
' So X = $B$2 or what ever address I'm at when I put it in to the variable during the loop. Moved on to the a range of cells that are selected and would know like to go back and Activate the Cell that = X

Thanks for any help you can give.

 

[mikerickson]

You could use

Range(x).Select

On the other hand, Selecting is ususaly unnessesary. This is one reason why it should be avoided. If your routine does not use selection, the ActiveCell will not change.

 

[Ritt]

See that was to easy I was putting to much in to it. Thanks a lot.