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]


wrote in message
oups.com...
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!