Add data to a excel table

[Av8tordude]

I have a table I would like to add the following code but i'm not sure how to do it since i never work with tables before.
The code simply inserts 1/1/2020 and sequentially inserts the following date in the same column.
FYI, I have a header row at BS6
Can someone assist.

Thank you kindly

            With Wks
                .Range("BS7") = "1/1/" & cboYear
                .Range("BS7").DataSeries Rowcol:=xlColumns, Type:=xlChronological, Date:=xlDay, Step:=1, stop:=DateSerial(Year(Range("BS7").Value), 12, 31)
            End With

 

[Av8tordude]

bump

 

[Av8tordude]

can anyone help with a solution?