First off, thank you for taking the time to read this and offer your input.
I am trying to create a squashed calendar (if there's an official name for it, let me know). Here's an example of what August 2012 would look like (sorry about using the code window, but that's the only way I can make it look right):
Basically, it wouldn't move down a row until the row above is completely filled. I'm starting with the calendar creator macro from the Microsoft website: http://support.microsoft.com/kb/150774. I removed all the fancy (and dare I say schmancy) formatting code and have it printing out a very basic looking calendar.
I won't post the full code, but here is the section that prints out the days:
By strategic use of msgbox, I'm able to stop the code at the point it gets to the end of the row:
I've gotten so far as:
And that's where I get stuck. I've tried to use the active.cell to move the cell.row to cell.row-1, but I'm not familiar enough with VBA to do it. My guess is that I can use
to know when to move back down a row...but I just can't figure out how to move the active cell - or is it the cell range? - up to where I need it.
If anyone can help me figure out what happend after "then," I'd really appreciate it.
Thanks in advance,
Dan
Bookmarks