Results 1 to 4 of 4

For Loop

Threaded View

  1. #1
    Registered User
    Join Date
    08-18-2008
    Location
    Los Angeles
    Posts
    44

    For Loop

    Here i am again with another problem, I am trying to copy a range of cells from 1 worksheet into another, and i am trying to do this in dynamic mode.
    here is my coding that obviously doesn't work, I surrounded the code that does not work with >>> <<<<
    Legend, Cnt1 points to the current rows and w2_tCol points to the ending column represented in number like column g = 7
            For cnt1 = 2 To w1_tRow
        
            Sheets("Temp2").Select
    >>>>   Range(Cells(cnt1, 1) & ":" & Cells(cnt1, W2_tCol)).Select  <<<<<       Application.CutCopyMode = False
            Selection.Copy
        
            Sheets("Temp1").Select
            Cells(cnt1, W1_Tcol + 1).Select
            Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
                :=False, Transpose:=False
        Next cnt1
    Last edited by Leith Ross; 08-04-2009 at 02:40 PM. Reason: Added Code Tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1