You have to write your code to properly handle the cancel

Dim temp_range as Range
On Error Resume Next
Set temp_range = Application.InputBox(prompt:= _
"Select Range for Operation",Type:=8)
On Error goto 0
if temp_range is nothing then
' user hit cancel
else
temp_range.Select
End if

The last several lines are just illustrative of taking action - you can
program whatever is appropriate in your situation.

--
Regards,
Tom Ogilvy


"Syed Zeeshan Haider" wrote in
message ...
"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