Hello everyone,
I have a macro that is performing a basic 'IF' function. I have included the code below. In case 1 the macro will run properly without fault. In Case 2 the macro throws an error "Run-time error '1004': AutoFill method of Range class failed." The only difference in the two cases is the range, Case 1 is around 2000 rows, Case 2 is around 500,000 cells.
I did not expect to see the error that i did, but can someone confirm if this is just a size of dataset error? Is there any way to fix it?
Case 1:
Case 2:
Bookmarks