Allowing a user to select an Excel range within a VBA macro
Q: In an Excel macro form I want my users to easily select a "range". What is the command in VBA? (I want something similar to a dialog box)
A: This is quite straightforward, and has many, many applications.
Sub SelectRange()
rngRange = Application.InputBox("Select a range", Type:=8)
End Sub