Thank you for your replies!

I tried both of your suggestions, but this is what happened: The
macro gave an output, but it gave the same output over and over. What
I wanted the macro to do was to perform the calculations only when a
variable for 2 is stored. So values for PT1 and PT2 would be
constantly reassigned. The macro would also have to be able to repeat
the process down the entire spreadsheet to find the other variables
for 2.

Thanks again,

Greg