One of the most powerful statements in VBA is Selection. This holds whatever the user has selected just before they ran the macro. Normally it is a range, but what if it isn’t?
If a user has a chart selected but he runs a macro that is expecting a range then an error usually occurs.
To identify what is selected when the macro runs you can use the TypeName statement as shown below.
Sub Testing()
If TypeName(Selection) = "Range" Then
'code to do something to a range
Else
MsgBox "Please select a range before running this macro"
End If
End Sub
A message box is displayed if the user hasn’t selected a range before running the macro.
Note: a single cell is still treated as a range in Excel.