thanks a ton it worked very well.
can the same formatting also be copied.

"pinmaster" wrote:

Copy then Paste Special/Values.

HTH
JG

"kamlesh" wrote:

i have a worksheet with formulas, i want to copy the absolute figures to
another worksheet, pl help