copying one entire row from a source sheet to a destination sheet

[Russ]

This is really simple. I have a loop with two variables, sr & dr. sr is the
source row in sheets("source") and dr is the destination row in
sheets("destination"). The sheets("destinaton") is empty at the start. What
is the line of code that will copy the entire source row sr in
sheets("source") to the entire dr row in sheets("destination")?

 

[Jacob Skaria]

Dim sr as Long,dr as Long

sr= 2
dr = 5

Sheets("source").Rows(sr).Copy Sheets("destination").Rows(dr)

If this post helps click Yes

 

[Russ]

Wow its that simple. Thanks a million!
--
russ

Dim sr as Long,dr as Long

sr= 2
dr = 5

Sheets("source").Rows(sr).Copy Sheets("destination").Rows(dr)

If this post helps click Yes