Thread: Using an Array to Speed-Up Range Copy
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
  
Posts: 417
Default Using an Array to Speed-Up Range Copy
With Worksheets("WORKPLACE")
.Cells(5, 4).Resize(totalrows, 183).FillDown
'or
.Range("D5").Resize(totalrows, 183).FillDown
End With
--
Regards,
Bill Renaud



Reply With QuoteReply With Quote