Thread: Copying records from sheet1 to sheet2??
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
j2dizzo[_5_] j2dizzo[_5_] is offline
external usenet poster
  
Posts: 1
Default Copying records from sheet1 to sheet2??

I can't get the code below to work with the code provided by Norman

'Clears a range of cells in Column A in sheet2
Me.Range("A16:A9999").ClearContents

'AutoFills column A in sheet2 using a range from the parent sheet
..Range("A16:A17").AutoFill Destination:=Me.Range("A16:A114")

Any help will be greatly appreciated.


--
j2dizzo
------------------------------------------------------------------------
j2dizzo's Profile: http://www.excelforum.com/member.php...o&userid=22016
View this thread: http://www.excelforum.com/showthread...hreadid=489770

Reply With QuoteReply With Quote