Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining Range of selected cell
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining Range of selected cell
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining Range of selected cell
Figured it out with that... Thanks!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determining if a chart is selected | Charts and Charting in Excel | |||
Determining end of user-selected range | Excel Programming | |||
Determining selected worksheet | Excel Programming | |||
Determining whether selected cell has value or formula? | Excel Programming |