Something for you to think about
Select the entire worksheet - by left click the box to the left of the "A"
and above the number "1" - then copy - then paste special - values - don't
need a macro to do that.

"Marcus A" wrote:

I wanted to know if there was a macro that would replace all formulas in a
worksheet with their respective value only.

Thanks.