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.