I posted this yesterday w/ no answers. So, I'm re-wording it.

I am running Access-to-Excel automation to
fill an Excel Column w/ Dates. It is setup to handle
52 Dates, but has only 40 weeks data so far.

So, IF "Column A" fills in 40 of the cells, it leaves the other 12 blank.

I need those other 12-cells filled in with W/E dates so a Trendline
will display on an Excel Chart as a "Target". Now, I just copy & paste
in the remaining 12 Dates.

I started recording this macro...

Application.Goto Reference:="AOne"
Selection.End(xlDown).Select
....rest.... ???
--- I would like to identify the rownumber of that cell (IE "A")
& compare it to the rownumber of the 52nd cell (IE "B"). I can
then "Find" that last-entered datevalue (the Contents in "A")
in a predefined column.

Then copy down "X' number of rows (to match the difference
between ["B" - "A" + 1] above).

Does anyone have existing code to do this?

TIA - Bob