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

(and please don't cross post)

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


-

wrote in message
ups.com...
I noticed in Excel there is a button for "paste special value" It
looks like a clipboard with the number 12 on it; it pastes the values.
I would like to have
something like that for pasting special - only for 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.