OK, now I'm REALLY confused.
WeeklyDates is a range object, correct? I had originally tried:
WeeklyDates.Range(Cells(1, StartCol), Cells(1, EndCol)).Copy
(which looks to me like it should be using the range property of the WeeklyDates range object, right?), but that ALSO gives an Error 1004.
And now you're saying that WeeklyDates(44,69) (in my example) would work? Where is that described in the VBA documentation? I can't find anything that describes a Range syntax like that. I thought you had to use the Cells property (when using row and column numbers, rather than an A1-style reference).