excel range
 

Hi:
How can I retrieve the currently selected range on the active shhet? Would
ActiveCell do the trick or do I need something else?
Cheers
Sean.



__________ Information from ESET NOD32 Antivirus, version of virus signature database 4035 (20090425) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

excel range
 

You would use the Selection range. For example...

MsgBox Selection.Address

The ActiveCell range is the individual cell that is selected... for a
selection, it is the cell within the selection that is not shaded.

--
Rick (MVP - Excel)


"Sean Farrow" wrote in message
...
Hi:
How can I retrieve the currently selected range on the active shhet? Would
ActiveCell do the trick or do I need something else?
Cheers
Sean.


__________ Information from ESET NOD32 Antivirus, version of virus
signature database 4035 (20090425) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

excel range
 

Hi Rick:
Thank you, once again.
Sean.
"Rick Rothstein" wrote in message
...
You would use the Selection range. For example...

MsgBox Selection.Address

The ActiveCell range is the individual cell that is selected... for a
selection, it is the cell within the selection that is not shaded.

--
Rick (MVP - Excel)


"Sean Farrow" wrote in message
...
Hi:
How can I retrieve the currently selected range on the active shhet?
Would ActiveCell do the trick or do I need something else?
Cheers
Sean.


__________ Information from ESET NOD32 Antivirus, version of virus
signature database 4035 (20090425) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com






__________ Information from ESET NOD32 Antivirus, version of virus
signature database 4035 (20090425) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com






__________ Information from ESET NOD32 Antivirus, version of virus signature database 4035 (20090425) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com