selecting range as input in VBA

M

moshe_xls

Hi,

I'm looking for VBA function (or script) that allows me to select range
(with mouse) as input (like the Excel SUM function for example).

Thanks
 
M

Mike H

Hi,

Do you mean this

Set myrange = Application.InputBox(Prompt:="Please select range", _
Title:="Range Selector", Type:=8)

MsgBox "You selected " & myrange.Address

Mike
 
Top