Determining the selection type

If you design your macro to work with a range selection, the macro must be able to determine whether a range is actually selected. If something other than a range is selected (such as a chart or a shape), the macro will probably bomb. The following procedure uses the VBA TypeName function to identify the type of object that is currently selected:

Sub SelectionType()
MsgBox TypeName(Selection)
End Sub

If a Range object is selected, the MsgBox displays Range. If your macro works only with ranges, you can use an If statement to ensure that a range is selected. This example displays a message and exits the procedure if the current selection is not a Range object:
Sub CheckSelection()
If TypeName(Selection) <> “Range” Then

MsgBox “Select a range.”
Exit Sub
End If
‘ … [Other statements go here]
End Sub

Leave a Reply

Name (required)

Mail (will not be published) (required)

Website