Okay, I changed things up and now there are no issues as far as running the macro is involved. My next question is, I'm pulling numbers into these cells from another worksheet based on an ID number but when the ID number isn't found on the other worksheet, the cell will appear as "#N/A". Is there a code I can enter into the macro that will convert all cells that are "#N/A" into a blank cell?

This is what I'm referring to:

\1

The last column is the sum of all numbers from the first two columns, but if any cell in the first two columns are "#N/A", then it cannot spit out a number in the last column. So I would like to enter a code in VBA to basically converts any cell that is "#N/A" to a blank cell. How do I do that?