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

  • Thread starter Thread starter Russ
  • Start date Start date
R

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")?
 
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
 
Wow its that simple. Thanks a million!
--
russ


Jacob Skaria said:
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
Click to expand...
 
Back
Top