Thread: How do I change this code?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_656_] Rick Rothstein \(MVP - VB\)[_656_] is offline
external usenet poster
  
Posts: 1
Default How do I change this code?
As a guess... change the -1 to 1....

..EntireRow.Copy .Offset(1, 1 - .Column)

Rick


"OrlaLynch" wrote in message
...
This copies a line up for me but I can't get it to copy a line down. How
do I
change it?

With ActiveCell

.EntireRow.Copy .Offset(-1, 1 - .Column)
End With

Reply With QuoteReply With Quote