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.

Dim strOriginalAddress As String

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

Hope this helps,
Gary Brown


"oldyork90" wrote:

> 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.
>

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

--
HTH...

Jim Thomlinson


"oldyork90" wrote:

> 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.
>

On Jun 10, 7:30 am, Gary Brown
<g.brown.takethispartouttocontac...@kinneson.com> wrote:
> Dim strOriginalAddress As String
>
> strOriginalAddress = ActiveCell.Address
> 'do stuff
> Range(strOriginalAddress).Select
>
> Hope this helps,
> Gary Brown
>
> "oldyork90" wrote:
> > 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.

Thank you both. Works as if I paid for it. :-)