VBA ActiveCell Range

  • Thread starter Thread starter dancing fish
  • Start date Start date
D

dancing fish

Hi All,

Can't do this simple bit of VBA.

Basically, due to various previous macros, you end up at a cell in th
worksheet. This cell varies, it could be any cell.

I want my macro to remember which cell this is, for instance, A20, suc
that I can then refer back to this cell later in the macro.

I cant do it. I feel such a fool!

Please help

df
 
When you have ended up at that cell, save a variable to it

Set oldCell = Activecell

Later on you can then refer back to oldCell.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top