Thank you both so much, this works great. My only question is - it
seems the answer (in the input box) must be a date.

Actually, it must be a number NOT specifically a date!

Would this code
work with another set of data in the H/8 column? I have one sheet
where
there are parts in this column (A713 for example), but when I try the
code for that it says "Number is not valid."

Set the carat inside the word InputBox and press F1 to see an
explanation for the 'Type' arg of that function. When the dialog opens,
type "inputbox" (without quotes) in the search box. Change it to suit
the type of data you want. (In this case it should be text; Type:=2)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion