Set myRange = Application.InputBox(prompt := "Sample",
type := 8)
I'm using VBA to have someone chose a cell range in an
excel program. The above statement was provided in the VBA
help menu under "input box". The input box works just fine
when you pick a cell and press OK. However this input box
also has a cancel button which returns "FALSE". As such
when you press CANCEL, the "Set" portion is looking for a
range input and it gets FALSE and gives a "type mismatch
error." Any way of fixing this??