Fastest method to convert all formulas to values?

[cbrf23]

Hi guys, quick question:

Is this the fastest method available to convert all cells to values?

ActiveSheet.Range(Cells(1, 1), Cells(63556, 256)).value = ActiveSheet.Range(Cells(1, 1), Cells(63556, 256)).value

 

[Scott Huish]

How about:

ActiveSheet.UsedRange.Value = ActiveSheet.UsedRange.Value

 

[cbrf23]

I actually have a function for getting the "true used range" (I dont like usedrange...) but I was just asking about the method in general.
ie:

range.value=range.value

perhaps that should have been my original example. lol.

 

[GTO]

Yes.