A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Paste Special Formula Multiply feature doesn't work anymore



 
 
Thread Tools Display Modes
  #1  
Old June 30th 09, 10:50 PM posted to microsoft.public.excel.misc
theleo
external usenet poster
 
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.
Ads
  #2  
Old July 1st 09, 01:12 AM posted to microsoft.public.excel.misc
Shane Devenshire[_2_]
external usenet poster
 
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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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:39 PM.


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