Results 1 to 8 of 8

Thread: Excel VBA Search For Find Duplicate Values In Two Lists

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 04-20-2013, 03:53 PM #1
    PcMax
    PcMax is offline
    Senior Member
    Join Date
    Oct 2011
    Posts
    135
    Rep Power
    15
    Hi,

    Thanks for the suggestions LalitPandey87

    I tested the code and adding the following line to insert the data sheet

    Code:
    Worksheets("Sheet1").Range("H1:H" & UBound(varFinalArr)) = Application.Transpose(varFinalArr)
    Reply With Quote Reply With Quote
  2. 04-20-2013, 05:21 PM #2
    LalitPandey87
    LalitPandey87 is offline
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    15
    you can also do it as below:
    Code:
    Worksheets("Sheet1").Range("H1").Resize(UBound(varFinalArr)).value = Application.Transpose(varFinalArr)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. VBA Code To Highlight Duplicate Values In A Column
    By shonu in forum Excel Help
    Replies: 6
    Last Post: 05-16-2013, 09:56 AM
  2. Unmerge Cells and Fill with Duplicate Values
    By princ_wns in forum Excel Help
    Replies: 3
    Last Post: 10-09-2012, 07:36 AM
  3. Sql Queries For search Update Delete on excel sheet from vba
    By princ_wns in forum Excel Help
    Replies: 2
    Last Post: 11-17-2011, 07:49 PM
  4. Find duplicate values
    By excel_learner in forum Excel Help
    Replies: 4
    Last Post: 10-24-2011, 12:10 PM
  5. Unique Large Values From Duplicate List
    By S M C in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 10-04-2011, 02:17 AM

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
  •  

Forum Rules