Assign current cell to a variable and re-select

I can't believe I don't know how to do this! I must be having a mental block!

I want to assign the active cell reference to a variable, then when my macro finishes, the variable's reference is made the active cell again.

For example, if F2 is my current cell, I want the variable CurCell to store the reference F2. When my macro finishes, I want the active cell to be the CurCell reference.

This code doesn't work, but this is what I'm trying to do:

Please Login or Register  to view this content.

I can't think - what am I doing wrong?

Thanks!

Originally Posted by Cumberland

I can't believe I don't know how to do this! I must be having a mental block!

I want to assign the active cell reference to a variable, then when my macro finishes, the variable's reference is made the active cell again.

For example, if F2 is my current cell, I want the variable CurCell to store the reference F2. When my macro finishes, I want the active cell to be the CurCell reference.

This code doesn't work, but this is what I'm trying to do:

Please Login or Register  to view this content.

I can't think - what am I doing wrong?

Thanks!

try

Please Login or Register  to view this content.

Thanks - that would seem to do the trick!

I also found a workaround by using Row and Column with Cells:

Please Login or Register  to view this content.

Good to see, and thanks for the response

Originally Posted by Cumberland

Thanks - that would seem to do the trick!

I also found a workaround by using Row and Column with Cells:

Please Login or Register  to view this content.

Thanx Guys,
I was looking for a way to do this