Thread: Moving a row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default Moving a row
Try:

Sheets("Sheet1").Range("A4:XX4") = Sheets("Sheet2").Range("A1:XX1").Value
Or
Sheets("Sheet1").Range("A4:XX4") = Sheets("Sheet2").Range("A1:XX1").Formula
Or
Sheets("sheet2").Range("A1:XX1").Copy Sheets("sheet1").Range("A4")

Tom
Reply With QuoteReply With Quote