Remember Range Address

[Ivan Howard]

Hi All,

I have a simple problem, but not sure how to do it.

I need to be able to record the active cell address in order to be able to go back to the same cell once I have run a macro. I think it is done with a "Target.Range" macro, but have no idea how to do it.

Please could someone give me a hand.

Thanks very much.

 

[VoG]

Try like this

Set cell = ActiveCell
'
'your code
'
cell.Select

 

[Ivan Howard]

Thanks very much Peter.

This works well, but to understand it properly the question I have is that when you hover over "cell" when in break mode, it shows the contents of the active cell and not the address. Will this hinder the result if there is more than one cell with the same content, or does it actually use the cell address?

 

[VoG]

It sets cell to the same range as the selected cell. It doesn't depend on its value.

 

[Ivan Howard]

Fantastic Peter - thanks very much!