Often, I want to freeze the results of a range resulting from formulas and then change the

Question:

Often, I want to freeze the results of a range resulting from formulas and then change the formulas to values. Create a macro that will find, based on the selected cell, the largest range of cells containing the current cell and turn all formulas into values.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: