thanks a lot. it worked!!

"Biff" wrote:

Hi!

Use Copy/Paste SpecialValues

Biff

"kamlesh" wrote in message
...
i have a worksheet with formulas, i want to copy the absolute figures to
another worksheet, pl help