Thanks for the welcome.
Even though the code is VERY simple and VERY untidy, I don't think the problem is with the code. But here it is anyways.
First it puts the formulas in an empty row. This row then obviously calculates all the values to #N/A
I then copy the formulas that have been entered into row 35,001 and paste it in the area where I need the values. This area consists of several rows that have been filtered using Autofilter. I thus only paste it into the visible rows.
It then calculates for quite some time. After this I delete the formulas from row 35,001
I make all rows visible again. Select all cells and Special paste them as values to remove the formulas.
At the end of all of this, the area contains the following:- Rows were columns L to AB are empty (this is correct)
- Rows were columns L to AB contain the values that were on sheet Prev_Orderwell (this is correct)
- Rows were columns L to AB contain #N/A where the index in column C did NOT have any corresponding data in Prev_Orderwell (this is correct)
- Rows were columns L to AB contain #N/A where the index in column C DID have corresponding data in Prev_Orderwell (MY PROBLEM)
When I paste the formulas from row 35,001 into the area, the values that are brought with the formulas is #N/A. It seems that not all the rows are getting time to recalculate before I copy the entire area and pastes it as values.
Any thoughts?
Bookmarks