convert to value
 

is there a function to convert the contents of a cell from its formula to
the result of the formula


(similar to:)
Range("A9:F100").Select
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

only in a more direct manner?


thanks in advance,
-mark

convert to value
 

Hi Mark

You can use the value property
http://www.rondebruin.nl/values.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"mark kubicki" wrote in message ...
is there a function to convert the contents of a cell from its formula to
the result of the formula


(similar to:)
Range("A9:F100").Select
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

only in a more direct manner?


thanks in advance,
-mark

convert to value
 

Range("A1").Value = Range("A1").Value

--
Regards,
Rocky McKinley


"mark kubicki" wrote in message
...
is there a function to convert the contents of a cell from its formula to
the result of the formula


(similar to:)
Range("A9:F100").Select
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

only in a more direct manner?


thanks in advance,
-mark

convert to value
 

worked G R E A T !!!
(thanks)

"Ron de Bruin" wrote in message
...
Hi Mark

You can use the value property
http://www.rondebruin.nl/values.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"mark kubicki" wrote in message
...
is there a function to convert the contents of a cell from its formula
to
the result of the formula


(similar to:)
Range("A9:F100").Select
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

only in a more direct manner?


thanks in advance,
-mark