Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find function for a Range failing in excel 2003 and giving subscriptout of range error 9 problem but works fine in excel 2000 | Excel Programming | |||
RANGE EXCEL copy cell that meets criteria in a range | Excel Worksheet Functions | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Excel 2000 VBA - Set Print Range in dynamic range | Excel Programming | |||
adding reference-to-range control to excel range | Excel Programming |