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