Results 1 to 2 of 2

Thread: if find the matched data in another work workbook copy the complete row

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 01-09-2014, 08:19 AM #2
    parscon
    parscon is offline
    VBAX Mentor
    Joined
    Feb 2012
    Posts
    406
    Location
    I found ,
    Replace the below line 
     F_Rng.Offset(, 1).Resize(, 20).Copy Parts.Cells(i, 2)
    with
    F_Rng.Cells.Offset(, 1).EntireRow.Resize(, 20).Copy Parts.Cells(i, 2)
    And FIXED .
    Last edited by parscon; 01-09-2014 at 08:37 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules