Thread: Copy Range to new Range and keep DATE format??
View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Copy Range to new Range and keep DATE format??
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
Reply With QuoteReply With Quote