Quote Originally Posted by Merf View Post
Doesn't it fit the Range(Cells(row1,col1),Cells(row2,col2)) syntax, since WeeklyDates is declared as a range?
No- a Range object is not the same as the Range property.

And if the snytax is wrong, why didn't it throw an error at compile time?
The syntax is OK, since the two cell arguments you pass could contain numbers, in which case something like weeklyDates(1, 2) would be perfectly acceptable.