Enter data in excel table

[Av8tordude]

I have this code that I used before using an Excel Table. Since then, its not entering the dates. The table name is tblSchedule.

            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

 

[jasonb75]

Have you tried stepping through and checking that your variables hold the correct values?