Autofill with max value assigned

Hello

I am trying to autofill dates down a column which i have done successfully. However I want the AutoFill to stop at a date I have specified in Cell "G13"

Please Login or Register  to view this content.

Where rStartCell "A54" is where the autofill starts, and rEndDate "G13" is where i specify the date where i want my autofill to stop. "A82" in the code is not important, it was just to test the autofill code

Essentially I want to stop the autofill at a date that I have specified in Cell "G13"

Thanks for your help

Hi, I solved my own problem with the code below

Please Login or Register  to view this content.