Excel VBA Formula & Cell Referencing

Hi Everyone!

I have a problem that involves cell referencing while executing a formula, i have two codes below, both are performing the same thing, however, the second one is not "iterating" which is because of the referencing. To provide background, in the second code, I'm referencing a specific sheet since the data I'm working on is being copied from one sheet to another. I'm not sure how to correct it though and any advice would be much appreciated.

1st Code:

Please Login or Register  to view this content.

2nd Code:

Please Login or Register  to view this content.