Thread: join sheet 2 below sheet 1
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
vikram vikram is offline
external usenet poster
  
Posts: 1
Default join sheet 2 below sheet 1
Dim vikram
Sheets("Sheet1").Activate
vikram = ActiveSheet.UsedRange.Rows.Count
Sheets("sheet2").Activate
ActiveSheet.UsedRange.Select
Selection.Copy Destination:=Sheet1.range("A" & vikram + 1)
End Sub

error occurs in "Selection.Copy Destination:=Sheet1.range("A" & vikra
+ 1)"

it says copy area and paste area are not same size

i have range from "a:z" in sheet 2 and the same range inn sheet

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

Reply With QuoteReply With Quote