Results 1 to 10 of 86

Thread: Copy Paste based on comparisons calculations in 2 XL files, 1 might be .csv file .Opened in XL=Fail/Chaos

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-27-2020, 02:50 PM #11
    DocAElstein
    DocAElstein is online now
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    The error is caused by bad understanding of Range.Find Method ( https://docs.microsoft.com/de-de/off...cel.range.find )

    We only need small amount of test data to demonstrate the problem: See here, for explanation of the problem: http://www.excelfox.com/forum/showth...ll=1#post13142

    I will post you a new macro later.

    Alan
    Last edited by DocAElstein; 04-27-2020 at 03:24 PM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
     Winston Churchill, 1939
    Save your Forum..._
    KILL A MODERATOR!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. VBA Dir File Copy and Paste: Check if file exists then copy file from one directory to another. Bat File
    By fixer in forum Test Area
    Replies: 26
    Last Post: 09-26-2020, 05:56 PM
  2. Copy paste data based on criteria
    By analyst in forum Excel Help
    Replies: 7
    Last Post: 01-13-2014, 12:46 PM
  3. VBA code to copy and paste row based on certain criteria
    By T0NT0 in forum Excel Help
    Replies: 8
    Last Post: 10-31-2013, 12:38 AM
  4. Copy data from 1 excel workbook to another based on certain criteria
    By Matt_M in forum Excel Help
    Replies: 2
    Last Post: 09-18-2013, 12:30 AM

Tags for this Thread

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