Code For Going to a Cell & Capturing The Value

Good Evening All,

It has been a while since I played with macros and sadly I have forgotten many of the basics. I am hoping someone can help me.

I have built a macro that does exactly what I want it to do to a specific stage and I can't seem to get the code right for the next bit and as a result I am close to abandoning it.

The code I have already written leaves the cursor on a specific cell. I want the macro to remember the value of that four digit number in that cell before it moves on. The cell it is on will move with time so I don't want to put a reference like A25 = Year.

I am guessing it has something to do with using Activecell.Value but I'm not sure.

I also want it to add one to that four digit number and remember also remember that in the macro so that I can use it further on.

Many thanks for any help.