Macro to run formula based on a range of data in some rows of a column REVISITED

On 5/28. I posted a problem under the thread

"Macro to run formula based on a range of data in some rows of a column"
http://www.excelforum.com/excel-prog...-a-column.html

Forum Contributor tehneXus provided a great solution. I assigned his code to a Macro called "Evaluate" (Ctrl + e) and it worked perfectly on the data set I had at the time (Rows 2 through 2048). So I marked the thread “Solved”.


Now, I have added new data (rows 2049 to 2621) and the Macro will not process the new data. I get no error messages, and it appears to run something in the background, but no data appears in columns N, O, P, & Q as it is supposed to.

See attached Zip file for the spread sheet as it exists now (with the macro and new data in place).

If tehneXus sees this post, or if anyone else can help, I would appreciate it.

Right on all counts. I did change some columns around without taking into account the impact on the routine.

Working on resolving the formula issues. All but one is done, and I hope to solve that as well....but if not, I'll likely be back. For now, a big THANK YOU for a job well done.