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.