something like this...

Dim rngFirstCell as Range, rngSecondCell as Range
Set rngFirstCell = ActiveCell 'Assuming E127 is the active cell here
Set rngSecondCell = Cells(2,2) 'i.e. B2

'---
'Code that does something to rngSecondCell
'---

rngFirstCell.Activate 'Go back to e127

On Apr 15, 1:16 pm, Richard wrote:
OS: MS Xp
Excel 2003

I am in say cell E127 and need t go to cell B2. I then need to return to
cell E127.
Problem is E127 is different each time. How do I read the cell address in
VBA so that I may return to it?
Thanks in advanced.
--
Richard