Sub yourmacro()

'some stuff gets done

Set sRange = Application.InputBox(prompt:= _
"Select the range of cells.", Type:=8)

'stuff gets done using sRange

End Sub


Gord Dibben MS Excel MVP


On Tue, 26 Sep 2006 11:53:02 -0700, tgaston
wrote:

How do I allow user selection of cells in the middle of a macro?