"Keith Willshaw" wrote in message ...

If you use the type argument with input box you can select
a range using the mouse

Dim temp_range as Range
Set temp_range = Application.InputBox(prompt:="Select Range for
Operation",
Type:=8)

Thanks! It is a good replacment of RefEdit for certain occasioans.

There is a problem. When I click Cancel button it raises error 424, that is
"Object required".

How can I get rid of this error?

Thank you