Squashed Calendar

[dank_01]

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):

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

By strategic use of msgbox, I'm able to stop the code at the point it gets to the end of the row:

Please Login or Register  to view this content.

I've gotten so far as:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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

[rylo]

Hi

this assumes that you have your headings in the range A2:G2, starting with Sun in A2.

Please Login or Register  to view this content.

Hopefully that will get you going.

rylo

[dank_01]

Hi Rylo -
Thanks for your suggestion. I tried it out using 8/1/2012, and it still prints out as a normal calendar with the 5th starting out on Row 4 instead of Row 3 - so no squashy love from it )-:
I've never seen the "evaluate" function before, so you did give me something new to research (-:

[rylo]

Hi

Sorry, completely misinterpreted what you were trying to achieve.

Try this.

Please Login or Register  to view this content.

rylo

[dank_01]

That was the trick. Thank you very much!