active cell - get me back there

[oldyork90]

NOT a vba guy... macros

I have on that does a lot of formating of a sheet. I want to return
to the cell that was active after the
formating macro is complete. I opened up the macro editor and tried
something like

a = activecell

then later on

a.activate

Thank you.

 

[Gary Brown]

Dim strOriginalAddress As String

strOriginalAddress = ActiveCell.Address
'do stuff
Range(strOriginalAddress).Select

Hope this helps,
Gary Brown

 

[Jim Thomlinson]

You are close. You want to store the activesheet and the active cell. So
something like this perhaps...

dim wks as worksheet
dim rng as range

set wks = activesheet
set rng = activecell

'your code here

wks.select
rng.select

 

[oldyork90]

Dim strOriginalAddress As String

strOriginalAddress = ActiveCell.Address
'do stuff
Range(strOriginalAddress).Select

Hope this helps,
Gary Brown

Thank you both. Works as if I paid for it.