say range 1 and 2 are on Sheet1, "A1" and "A2"...

'Check for start date
If Sheet1.Range("A1") = "" OR (Not IsDate(Sheet1.Range("A1")) then
'Flag message and exit routine
end if

Then do same for end date.

nbaj2k wrote:
Right now I have 2 cells in the top left of my spreadsheet that are set
to be parameters. One is the start date and one is the end date. I
would like to know if there is a way to have a message box come up if
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 how
it would be written.

Thanks,

~J


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=566989