I am looking for a macro that will seperate and add the next day.

When I use this worksheet, sometimes I input multiple days at a time so
the now function wouldn't work. But i would like to be able to run a macro
that will look and see what the last day entered was in column B. Insert a
break of some sort. Preferably fill cells A:Q solid black. How they are
seperated is unimportant. Just something to show the end of a day. For
example, if cell B26 is my last entry, and it was 11/23/2004. Starting at
A27, Fill cells A27:P27 with a black background, and in those cells in white
bold font enter 11/24/2004.

Thanks in advance for your help,
Steve