Formatting question

[coopman64]

I'm working on a schedule macro that puts the day and date at the top of each page, but it has both the day and date together. Is there a way to align the day left and the date right? This is the line that I'm using to insert the day and date.

Please Login or Register  to view this content.

Is there anything I can insert between dddd and mmmm to adjust the alignment?

[arlu1201]

You can insert spaces or you can put the day in one cell and date in one cell.

[coopman64]

I tried inserting spaces but that doesn't work too well. "A1" was a merged cell, so I split it into "A1" and "G1" and tried

Please Login or Register  to view this content.

but it didn't like that.

Is there a way to put a choose weekday formula in "A1" and the date in "G1"?

[arlu1201]

Is the N a variable or is it the column N?

[coopman64]

ok, that solved that problem, N is a variable for the row. I changed the cell number and it works, except all I get is the first letter of the day instead of the entire day. I have format in as dddd

[arlu1201]

So do you have anything else pending in this thread?

[coopman64]

Yes, it's only giving showing the first letter of the weekday name instead of the entire
Name.

[arlu1201]

Is this the code you are using?

Please Login or Register  to view this content.

[coopman64]

That's what I had but when you asked if N is a variable ( which it is) I changed G1 to cells(2, N). Finally realized the reason I kept getting just the first letter of the weekday is because cells(2, N) is the choose weekday formula which refers to the date on cells(1, N). In short, that's the code I'm trying to use

[arlu1201]

You can have the cell populate the date like -

Please Login or Register  to view this content.

and then add this line -

Please Login or Register  to view this content.

P.S - Change the bold section to match your file.

[coopman64]

Thank you, that worked