Adding to a macro recording

Attached you will find two files.

Generator4.0 is a blank file that I will paste a report into and then run the macro using Ctrl+Shift+C.

ForumExample is the before and after results of my macro recording attempt

But.....

I forgot to center columns B,C,D,F,G,H,I,K,L & M at the end of the report. What code is required to do so?


The following is desirable, but far beyond my skill set.......


1. Is it possible to add 'All Borders' to just the remaining data?

2. Is it possible to add the fill color to black and the font color to white for all dates in Column G for the date before the day I run the report?

3. Is it possible to add the fill color to black and the font color to white for all dates in Column H for the dates three days from the day I run the report?


Thank you in advance.

I was tidying up the code before adding the new functionality but as Kasper has kindly sorted that bit for you I've just added their code to my rewrite below.

See attached.

Please Login or Register  to view this content.

BSB

This is amazing. Thank you. It feels wrong that I'm getting this for free. Can I pay this back somehow?


I think my request below was wrong.

'3. Is it possible to add the fill color to black and the font color to white for all dates in Column H for the dates three days from the day I run the report?'


I am looking for the fill in column H to be for only the 3rd day after the report is run (and now I think about it - the 4th also).

In fact, I would like the two days after I run the report to be filled in grey.

Is this something you can do ?

Originally Posted by Kaper

As for posiible "paying back": Well, on the public part of the forum we (hope BadlySpelledBuoy would agree) do it mostly just for fun, or to test ourselves, or to train/keep our skills form rusting :-)

Wholehearted agree. I do it for fun and to help others. "Playing with Excel" is my day job and helping others on here often forces me to think of solutions for problems that I wouldn't usually encounter.

BSB

In hindsight, I see I did not make myself clear.

Today is the 2nd December.

I am looking for a black fill with white text in column G for the day before the report is run. (1st December)

And the same in Column H, 3 & 4 days from now (5th & 6th December)

And if possible - to throw one more thing in there - a medium grey fill for tomorrow (3rd) and the next day (4th)

(I have to say - I also enjoy excel as a hobby, helping my colleagues - like I am with this - and wish I could code like you both.) Thank you.