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?

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?

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?