Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Special Formula
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to copy a conditional format formula as paste value | Excel Discussion (Misc queries) | |||
Is it possible? | Excel Worksheet Functions | |||
Paste Special and Paste Object | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Paste Special Question | Excel Discussion (Misc queries) |