.copy only value not formula

[vizzkid]

Is there anyway to use the .Copy operator to copy only the value, not the function of a cell?

[zbor]

Copy
Right click Paste special (not just paste)
check box Values

[AB33]

use

Please Login or Register  to view this content.

[vizzkid]

Thank you AB33! Perfect!

[AB33]

E.g

Please Login or Register  to view this content.

[AB33]

Zbor,
you have typo
spetial

[zbor]

Thx, corrected.. I didn't see at first it's on Macro subofrum.