Results 1 to 20 of 31

Thread: Whats wrong with my code, copy paste does not change Array formula

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Sep 2016
    Posts
    44
    Location

    Whats wrong with my code, copy paste does not change Array formula

    Basically the Macro copies data from The Drawn Numbers sheet to the Input sheet starting at row 49. When it paste it in I49:N101 the Array formula in B49:G101 does not change or match its corresponding cells I49:N101 and I can not figure out why. Once Macro is ran B49:G49 is not the same as I49:N49 and so on down

    I am not concerned with the Macro error because it works fine in a normal book. I want to know why the Array 49:G101 does not follow the numbers in I49:N101 when you click on the Grabber button

    perhaps a calculate statement somewhere?
    Attached Files Attached Files
    Last edited by MrSams; 10-01-2016 at 08:45 PM.

Posting Permissions

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