AutoFill Month Error

[alsharif]

In a Worksheet I have to columns A (Data) and B (Dates) and I need to 'AutoFill the date in Column B starting from last month in column B till the end of the last cell on Column A using the Auto fill method only but it is giving me this error .

please help me with code correction

thank you

 

[Fluff]

The destination range should be

Range("B" & lastrow_b & ":B" & lastrow_a)

 

[alsharif]

The destination range should be

Range("B" & lastrow_b & ":B" & lastrow_a)

Wooow, It is working like Magic? ,

You are great?

thank you very much for your fast reply and your effort..?

 

[Fluff]

You're welcome & thanks for the feedback.