CopyEditPasteSpecialValues.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JudiS" wrote in message
...
Hi,
I received this question from a Excel user:

'I have a worksheet that has cells with data looking at other worksheets.
I
want to basically hard code those #'s without actually deleting the
formula
and typing the number in.

How do I do that?'

Thanks for any information that you may have!