How do I change this code?

  • Thread starter Thread starter OrlaLynch
  • Start date Start date
O

OrlaLynch

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
 
As a guess... change the -1 to 1....

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

Rick
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if and then 3
MACRO COLUMNS, SKIP ROWS 6
MACRO assistance 1
MACRO PASTE CELL to COLUMN, SKIP ROWS 1
Run-time error when copying entire row! 5
Macro to Insert and copy entire row 3
Macro change problem 3
My code need to go on a diet 10

Back
Top