Range("A1:A7").value <""

raises an error for me.


--
Regards,
Tom Ogilvy


"Corey" wrote in message
...
Depends on how you have each day set up.
If you have a daily cell value with hours in it you could use something
like:

If Range("A1:A7").value <"" then msgbox "The Employee has worked 7 days
straight."
' Where A1:A7 is the hrs worked for each day.

Corey....
wrote in message
ps.com...
I have an excel timesheet that I want to do a simple task - count if an
employee ever works 7 days in a row.

Any Ideas?

Thanks,

Patrick