Rewrite: c.EntireRow.Copy AND c.Offset(1, 0).EntireRow.Copy

[Captain_Conman]

This is probably a stupid question...

While looping through column A, if a certain condition is met, I would like to copy the active row, and the row below it.

c.EntireRow.Copy AND c.Offset(1, 0).EntireRow.Copy

What is the best way to write this?

 

[Joe4]

One way:

    Rows(c.Row & ":" & c.Row + 1).Copy

 

[Captain_Conman]

Thanks Joe!

I appreciate it.

 

[Joe4]

You are welcome!