Results 1 to 4 of 4

Copy and Paste rows

Threaded View

  1. #1
    Registered User
    Join Date
    04-22-2009
    Location
    Boston
    MS-Off Ver
    Excel 2013
    Posts
    68

    Copy and Paste rows

    Hi,

    I want to copy and paste row in sheet 3 to the row in sheet 1.
    Since the row no is a variable, i m having difficulty in writing the right formula.
    Please help.

    Dim i as Integer
    i=14 ' i keeps on changing ..here sample value is taken as 14
    ' Copy and paste the range A14:AF14
      Sheets("Sheet3").Select
            
       Range("A" & CStr(i) & ":" & "AF" & CStr(i)).Select
       Selection.Copy
       Sheets("Sheet1").Select
       Range("A" & Cstr(i) & ":" & "AF" & Cstr(i)).Select
        ActiveSheet.Paste
    Above code doesn't work
    Last edited by kapilrakh; 11-13-2009 at 04:06 PM.

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