target address

  • Thread starter Thread starter Mark Kubicki
  • Start date Start date
M

Mark Kubicki

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?
 
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
 
Selection.address with give the address of the area selected

selection.rows.count will give how many rows are selected etc.
 
Back
Top