| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying one entire row from a source sheet to a destination sheet
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")? -- russ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copying one entire row from a source sheet to a destination sheet
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 --------------- Jacob Skaria "Russ" wrote: 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")? -- russ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copying one entire row from a source sheet to a destination sh
Wow its that simple. Thanks a million!
-- russ "Jacob Skaria" wrote: 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 --------------- Jacob Skaria "Russ" wrote: 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")? -- russ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copied formulas refer to destination sheet not source sheet | Excel Worksheet Functions | |||
| sort source data sheet while destination shows same data | Excel Worksheet Functions | |||
| Copying formatting of entire sheet | New Users to Excel | |||
| copying and pasting from source sheet to destination sheet without naming source sht? | Excel Programming | |||
| Hyperlinks - identifying source in destination sheet | Excel Discussion (Misc queries) | |||
Linear Mode
