Get the address of selection : Selection « Excel « VBA / Excel / Access / Word






Get the address of selection

 
Sub getSelectionAddress
   Selection.Address
End Sub

 








Related examples in the same category

1.Is the current selection a Range
2.Determining the type of selected range
3.Returns a count of all cells in a selection: using the Selection and Count properties
4.Returns a count of the number of rows in a selection
5.Returns a count of the number of columns in a selection
6.Counts columns in a multiple selection
7.To add a range name based on a selection
8.Get selection address
9.Toggling a Boolean property
10.Selection move down
11.Code does / does not use With-End With
12.Find next heading