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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Special Formula
Why not try, Edit Paste Special, and then clicking the formulas radio
button? -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "LymaBeane" wrote in message oups.com... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Special Formula
That is what I do now. There is a quicker way for pasting values (the
clipboard button with the number 12 on it on the toolbar). But there isn't any button for pasting just the formulas. Thought there might be a macro that might do it. Andy Wiggins wrote: Why not try, Edit Paste Special, and then clicking the formulas radio button? -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "LymaBeane" wrote in message oups.com... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Special Formula
Use the macro recorder to record Edit Paste Special: Formulas, then attach
it to your own button. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "LymaBeane" wrote in message ups.com... That is what I do now. There is a quicker way for pasting values (the clipboard button with the number 12 on it on the toolbar). But there isn't any button for pasting just the formulas. Thought there might be a macro that might do it. Andy Wiggins wrote: Why not try, Edit Paste Special, and then clicking the formulas radio button? -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "LymaBeane" wrote in message oups.com... 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Special Formula
I already did that as I mentioned earlier in my post.
Andy Wiggins wrote: Use the macro recorder to record Edit Paste Special: Formulas, then attach it to your own button. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "LymaBeane" wrote in message ups.com... That is what I do now. There is a quicker way for pasting values (the clipboard button with the number 12 on it on the toolbar). But there isn't any button for pasting just the formulas. Thought there might be a macro that might do it. Andy Wiggins wrote: Why not try, Edit Paste Special, and then clicking the formulas radio button? -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "LymaBeane" wrote in message oups.com... 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. |
Reply |
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) |