VBA - drag down formulas to today's date

[rowbro]

Hi there - I am fairly new to VBA, having mainly recorded macros (and tinkered with them a little) in the past. I am now trying to drag formulas in the final row of a worksheet (columns A:R) from the final date in the worksheet to today's date (dates in the A column). However, when I try this using a recorded macro it takes the absolute location of a cell, and so drags down the same row every time. Is there some way to select the LAST ROW of data and drag it down X cells, where X is the difference between today's date and the last date in the A column?

Thanks!

 

[Arithos]

Awesome. Thanks for all the help.

Glad it worked!