Value Sheet
 

Hi. Is there a quick way in code to range value an entire sheet?
Thanks!

Value Sheet
 

Cells.Copy
Cells.PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

--
HTH,
Gary Brown

If this post was helpful to you, please select
''''''''''''''''YES'''''''''''''''' at the bottom of the post.



"Steve" wrote:

Hi. Is there a quick way in code to range value an entire sheet?
Thanks!