I am receiving an object required error on the following line within the context below. The variable StartDate is a Date data type. I would like for RngStart to be a Range value that I can plug in to the line: ActiveChart.SetSourceData Source:=Sheets("ActiveSheet").Range(RngStart, RngEnd)
The...