It actually copies everything, you make the choice when you paste. Try paste
special - value

"nc" wrote:

Hi Guys

I will be grateful if you can solve my problem
Whenever i am copying formula from one worksheet to another worksheet,
it is copying the contents of formula itself (e.g. ='worksheetA'!D12)
not the formula result.

Thanks
nc