Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste Special Formula
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste Special Formula
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste Special Formula
Didn't know I couldn't cross post. Sorry.
I answered you on the other post. Andy Wiggins wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste Special Formula
i think he multiposted, not crossposted. neither is a real good idea, but, in my
opinion, if you need to do one, use crossposting. at least the replies are sent to every ng and someone can see there was an answer posted. if it was multiposted, someone would have to visit the ng the reply was sent to to view it. sometimes i see replies in this ng that say, "see the answer in your other ng post". well, that doesn't do me any good, because i don't visit that other newsgroup the see the reply. if it was crossposted, i would see the reply. that's my opinion, anyway -- Gary "Andy Wiggins" <contact me via my website at www.BygSoftware.com wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Special Formula Multiply feature doesn't work anymore | Excel Discussion (Misc queries) | |||
Paste special with combination of formula and divide | Excel Discussion (Misc queries) | |||
Prefacing a Copy/Paste Special formula with text | Excel Worksheet Functions | |||
Paste Special Formula | Excel Worksheet Functions | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming |