I am trying to set a variable to a range by using an input box. Basically
it's a macro that will ask a user what range of cells the data they are
looking for is in, but I can't seem to get it. I tried it once and entered
C1:C120 into the input box but then I got an error that said Object variable
not set (and the debug highlight was on the input box for the range.

Any help?