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