If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




Paste Special Formula Multiply feature doesn't work anymore
Has anyone noticed that the "Paste Special > Formula > multiply" feature
does not work and it works instead the same as "Paste Special > Values > multiply"? In Excel in 2003 I was able to copy a formula like '=$A$1' then "Paste Special > Formula > multiply" onto a second cell (call it A2=$Z$1) and get a new formula in A2 = $Z$1*$A$1. Example: Z1 = 5 A1 = $Z$1 A2 = 100 Copy cell A1 & click cell A2 In Excel 2003, "Paste Special > Formula > multiply" would result in cell A2 becoming =100*$Z$1 In Excel 2007, "Paste Special > Formula > multiply" is resulting in cell A2 becoming =500 (inherent calc being 100*5) This suggests that Excel 2007 has a bug in feature "Paste Special > Formula > multiply" because it works instead as Excel 2007, "Paste Special > Values > multiply" Has anyone found a solution from Microsoft. I can create a macro but I use to use that feature a lot and don't want to create a macro every time. Help will be appreciated. Thanks. 
Ads 
#2




Paste Special Formula Multiply feature doesn't work anymore
Hi,
This is a known issue, and pretty annoying for some of us. Other than writing VBA code to do it I don't know if there is a workaround. Here is a little code you would attach to a VBA user form (the rngFrom and rngTo are the name of two refEdit controls. Private Sub btnOK_Click() Dim X X = Mid(Range(Me.rngFrom).Formula, 2, 10) Range(Me.rngTo) = Range(Me.rngTo).Formula & "*" & X Unload Me End Sub Private Sub btnCancel_Click() Unload Me End Sub You also need to display the form with code like this: Sub PasteSpecialMultiply() frmPasteSpecialM.Show End Sub  If this helps, please click the Yes button. Cheers, Shane Devenshire "theleo" wrote: > Has anyone noticed that the "Paste Special > Formula > multiply" feature > does not work and it works instead the same as "Paste Special > Values > > multiply"? > > In Excel in 2003 I was able to copy a formula like '=$A$1' then "Paste > Special > Formula > multiply" onto a second cell (call it A2=$Z$1) and get > a new formula in A2 = $Z$1*$A$1. > Example: > Z1 = 5 > A1 = $Z$1 > A2 = 100 > > Copy cell A1 & click cell A2 > > In Excel 2003, "Paste Special > Formula > multiply" would result in cell > A2 becoming =100*$Z$1 > > In Excel 2007, "Paste Special > Formula > multiply" is resulting in cell > A2 becoming =500 (inherent calc being 100*5) > > This suggests that Excel 2007 has a bug in feature "Paste Special > Formula > > multiply" because it works instead as Excel 2007, "Paste Special > Values > > multiply" > > Has anyone found a solution from Microsoft. I can create a macro but I use > to use that feature a lot and don't want to create a macro every time. Help > will be appreciated. Thanks. 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
help: paste special with an operation (add, multiply,...)converts everything to values, pasted formulas & links are lost  [email protected]  Excel Discussion (Misc queries)  0  March 10th 09 10:38 AM 
Paste Special Multiply Formulas not working in Excel 2007  el_guapo  Excel Worksheet Functions  1  September 25th 08 08:30 PM 
Paste Special  Formulas  Multiply  [email protected]  Excel Discussion (Misc queries)  4  February 4th 08 03:45 PM 
Can't Access Paste Special Anymore  Joe VW  Excel Worksheet Functions  5  November 4th 06 04:06 PM 
why don't my functions in paste special work?  Gene  Excel Worksheet Functions  2  September 10th 06 05:33 PM 