Thread: copy and paste table in another existing worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
BrianB BrianB is offline
external usenet poster
  
Posts: 1
Default copy and paste table in another existing worksheet
Dim LastCell As Range
Set LastCell = Worksheets("Sheet2").Range("A1").End(xlDown)
Worksheets("Sheet1").Range("A1:Z100").Copy Destination:=LastCel

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote