Hi
try something like the following:
sub foo()
with activesheet.range("A1")
if .value="" then
msgbox "Cell A1 has to be filled - Macro stopped"
exit sub
end if
end with
'now your code
end sub

--
Regards
Frank Kabel
Frankfurt, Germany


Grace wrote:
There is one cell input I have that is disastrous if it is skipped.
So, I'd like my macro to go to that cell, then instruct the operator
to choose from a dropdown list already incorporated into that cell
(via data, validation, list) and then, after he has done that, click
continue or Ok, so the macro moves on. Can someone give me the code
for this?

Thanks,
Grace