아래 코드를 표준 모듈에 넣으세요

Sub GetRange()

Dim Rng As Range

On Error Resume Next

Set Rng = Application.InputBox(prompt:="Enter range",Type:=8)

If Rng Is Nothing Then

MsgBox "Operation Cancelled"

Else

Rng.Select

End If

End Sub