Hi all,

I'm wondering what the "proper" way to handle the following problem is. I have the following piece of code, which works fine unless the user clicks cancel on the inputbox:

Dim SecondRange As Range
Set SecondRange = Application.InputBox("Enter cell range of values for 2nd series:", "Specify Range", , , , , , 8)
Obviously, the problem is that when the user clicks cancel, the result is not a range, so setting SecondRange to this result creates an error. I know I could use "on error goto ..." but I'm just looking for the "proper" way to handle this. I feel like gotos and labels are a bad way to program - maybe I'm wrong though.

Thanks in advance!