Thread: Autofill Dynamic Range of Cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] benmcclave@gmail.com is offline
external usenet poster
  
Posts: 29
Default Autofill Dynamic Range of Cells
Hi Keri,

This worked for me:

LastRow = ActiveSheet.Range("A1").End(xlDown).Row
Range("CR2:DC2").AutoFill Destination:=Range("CR2:DC" & LastRow)

-Ben
Reply With QuoteReply With Quote