LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 129
Default Most efficent code to copy a row on one sheet to a row on another

I'm writing a run of the mil VBA Sub that iterates through one
worksheet and copies selected rows in another sheet. The row has 20
columns of data.

If

Dim i as Integer
Dim j as Integer
Dim s1 as Worksheet
Dim s2 as Worksheet
Dim b as Workbook
set b = ActiveWorkbook
set s1 = b.Sheets(1)
set s2 = b.Sheets(2)
i = 3
j = 7

' Most efficent code to copy 20 columns of data from s1.Rows(i) to
s2.Rows(j)
' I'd prefer not to have a For loop that iterates through 20 cells for
each row.

Thanks.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VB code to copy sheet format to another sheet ASU Excel Discussion (Misc queries) 12 August 10th 06 02:37 AM
How do i copy a active sheet to a new sheet with code and everything Karill Excel Programming 2 April 11th 06 06:22 PM
efficent find all and value Ben Excel Programming 6 October 21st 05 12:38 AM
Copy sheet without Code xcelion Excel Programming 4 July 7th 05 04:15 PM
Copy Sheet w/o VBA code Ron de Bruin Excel Programming 1 January 20th 04 04:42 PM


All times are GMT +1. The time now is 07:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"