Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 30th 09, 10:50 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2009
Posts: 1
Default 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.

  #2   Report Post  
Old July 1st 09, 01:12 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3,346
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 09: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 02:45 PM
Can't Access Paste Special Anymore Joe VW Excel Worksheet Functions 5 November 4th 06 03:06 PM
why don't my functions in paste special work? Gene Excel Worksheet Functions 2 September 10th 06 05:33 PM


All times are GMT +1. The time now is 03:42 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017