Paulked,

Ah! That was it, I had the wrong Sheet#! I now put this code into my 35M workbook. It is running, but taking a long time to run. The workbook has a lot of nested formulas which is what probably makes it big. Is there a way to speed it up? May put in Application.Calculation = xlCalculationManual? If so, would I put it in the loop or maybe at the top of the program?

Thanks for all of your expertise help! How did you learn VBA? I have learned a lot from you. But wondering how you became an expert.

Steve