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.