Fill blank cells in column with consecutive end-of-month dates

[fruela]

Hi all, new to VBA and about to fully automate my first report, thank to videos, books and mrexcel.

Not sure how to approach this last one... so for column Q, fill blanks with consecutive end-of-month date, same range as column W.

Result (for cells below 31/10/2020):
30/11/2020
31/12/2020
31/01/2021
etc

Found this thread, but dates are fixed, and in my case they may vary each report:

VBA Macro to Return Consecutive Month-ends

This is my first ever post on this website. I need help on some VBA code that will put 31/07/00 into cell “B2” and then each month-end date down the column and stop at 31/11/2010 in cell “B126” (ie.

stackoverflow.com

Cheers

 

[Fluff]

How about

Sub fruela()
   With Range("Q2:Q" & Range("W" & Rows.Count).End(xlUp).Row)
      .SpecialCells(xlBlanks).FormulaR1C1 = "=eomonth(r[-1]c,1)"
      .Value = .Value
   End With
End Sub

 

[fruela]

Super perfect, thank you Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.