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

Hi,

Do you mean this

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

MsgBox "You selected " & myrange.Address

Mike

"moshe_xls" wrote:

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

Thanks,

This is exactly what I looked for :)


"moshe_xls" wrote:

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