You code produces the same result even on an empty workbook.
The month and day are reversed.

The copy method does work, I've been testing it alot to make sure.
I dont understand why .value=.value does not work...
I wish someone would be able to explain this to me for future
reference.

On Jul 13, 4:02*pm, Dave Peterson wrote:
Does my first suggestion work in a test workbook?

Are you sure this worked?

" wrote:

Well I guess I will have to use

ThisWorkbook.Sheets("Settings").Range(TempWeekRang e + "10" + ":" +
TempWeekRange + "15").Copy _
* Destination:=ThisWorkbook.Sheets("Settings").Range (TempWeekRange +
"10" + ":" + TempWeekRange + "15")
At least this one works... :)

--

Dave Peterson