I am trying to write a macro to remove duplicate records from a cs
file. The problem that I am having is that I am trying to allow th
user to select a range via an input box:

dim check as range

Set check = Application.InputBox(prompt:="Select with the Mouse th
Area you would like to check for Duplicates.", Type:=8)

That works fine, but If the user hit's cancel then the the macro error
out with a runtime error 424 Object required.

Any Recomendations

--
Message posted from http://www.ExcelForum.com