Right now I have 2 cells in the top left of my spreadsheet that are se
to be parameters. One is the start date and one is the end date.
would like to know if there is a way to have a message box come up i
someone tries to run the macro without having a date in the box
instead of having it error out.

I know there is a way and it would be an If statement, but not sure ho
it would be written.

Thanks,

~

--
nbaj2
-----------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...fo&userid=3648
View this thread: http://www.excelforum.com/showthread.php?threadid=56698