selecting range as input in VBA
 

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

selecting range as input in VBA
 

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

selecting range as input in VBA
 

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