Excel Table not extending date column down with VBA, but rest works ok?

[atombomb99]

Hi Group,
You kindly helped me with some VBA a year ago and I managed to adapt it to so many things - thankyou so much.

I'm a bit stuck with something that used to work, but I'm sure suddenly stopped.

It's a table like this:

Screenshot 2020-12-06 at 21.57.32.png

So that it does this:

Screenshot 2020-12-06 at 21.58.24.png

The code I managed to get working in a similar tab works, but I just can't seem to solve this despite my brain nearly exploding

This is the code:

Please Login or Register  to view this content.

When I run this, it does this, and extends the table, but not the dates in column B:

Screenshot 2020-12-06 at 21.59.53.png

(fields C72 - C76 have a formula in and would automatically calculate, but for some reason, the Macro has stopped dragging the date down to the current month).

I'm sure it must be something simple, and I've really tried to emulate another sheet in another workbook I have but I'm totally stuck. I just wondered if anyone could see anything obvious?

Any help greatly appreciated.

Best Regards,
Paul

[Squeaky]

Hi atombomb99,
Have you tried running the macro by pressing F8 (when in VBA) one line at a time to see which line it messes up at? Knowing that will be helpful. Also note which line it determines is the last line in B with a value.

Squeaky