How do I determine which cell is currently highlighted? I'm trying to
create a macro that will resort some data based on one columns value. I
have that part working, but after it's sorted i want to select the cell
that was originally selected before the macro ran. I tried searching
but couldn't figure out the proper search to use (i.e. the right
keywords to get what i want).

Any help?

Hi Mark,

Just to get you started:
Sub GetAddress()
MsgBox ActiveCell.Address
End Sub

--
macropod
[MVP - Microsoft Word]


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> How do I determine which cell is currently highlighted? I'm trying to
> create a macro that will resort some data based on one columns value. I
> have that part working, but after it's sorted i want to select the cell
> that was originally selected before the macro ran. I tried searching
> but couldn't figure out the proper search to use (i.e. the right
> keywords to get what i want).
>
> Any help?
>

Figured it out with that... Thanks!