Info only.

You don't need a macro to do this.

Just copy the range and editpaste specialvaluesOKEsc

If you want a macro, turn on the macro recorder while doing the above steps.

OR use the macro provided by Gary's student.


Gord Dibben MS Excel MVP

On Thu, 21 Sep 2006 08:12:02 -0700, Marcus A <Marcus
wrote:

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

Thanks.