| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
target address
if a user chooses more than one cell;
is there a way to determine the extent of the range chosen, if it is more than 1 row / column, which rows/columns are selected, etc? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
target address
Do you mean something like this Mark
Sub test() MsgBox Selection.Cells.Count MsgBox Selection.Rows.Count MsgBox Selection.Columns.Count MsgBox Selection.Address End Sub -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Mark Kubicki" wrote in message ... if a user chooses more than one cell; is there a way to determine the extent of the range chosen, if it is more than 1 row / column, which rows/columns are selected, etc? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
target address
Selection.address with give the address of the area selected
selection.rows.count will give how many rows are selected etc. "Mark Kubicki" wrote in message ... if a user chooses more than one cell; is there a way to determine the extent of the range chosen, if it is more than 1 row / column, which rows/columns are selected, etc? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
| Using Target.Address in Excel 98 | Excel Discussion (Misc queries) | |||
| Target.Address syntax | Excel Worksheet Functions | |||
| How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
| LINKING Address cells from an EXCEL spreadsheet to fill MapQuest Address Info | Excel Programming | |||
Linear Mode
