Why not try, Edit Paste Special, and then clicking the formulas radio
button?

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"LymaBeane" wrote in message
oups.com...
I noticed in Excel there is a button for "paste special value" It
looks like a clipboard with the 12 on it. I would like to have
something like that for pasting special - only formulas. Is there a
way to do that? I tried to create a macro doing that and it didn't
work. I even Googled it and found some VB code but it only pasted the
formula with the exact same column reference in another column.

I do a lot of copying and pasting and would like to click one button if
possible for copying a formula so that no formatting gets messed up.

Any help would be greatly appreciated.