Forum Discussion
Solved
Dynamic EOMONTH VBA code
How do i amend the code below in way which it could display the months in column A using the EOMONTH formula? Kind of got stuck on how to input my i in the for loop The placement of the highlight...
hrh_dash Now, I'm far from an expert in VBA but I believe you need to move the Set period1 step into the For i loop and change it to:
Set period1 = period.Offset(i)
hrh_dash Now, I'm far from an expert in VBA but I believe you need to move the Set period1 step into the For i loop and change it to:
Set period1 = period.Offset(i)
thank you for the assistance!