Macro =sum function not working correctly

[crowdx42]

Hi again,
so I have recorded a macro where there are two cells being added together and divided by another cell value. This worked fine on several pages of the work book but now as I move through the book it is giving false results.
Is there a problem with what was recorded?
I have listed below and what I want the formula to do is add E+F and then divide by G and run through a column doing the same thing.
What seems to be happening with the current macro is that it is getting stuck and is then returning the result for the first cell in the column.
Any help welcome
Patrick

Range("P6").Select
ActiveCell.FormulaR1C1 = "=SUM(RC[-11],RC[-10])/RC[-9]"
Range("P6:P45").Select
Selection.NumberFormat = "0.00"

[Gary''s Student]

Let's put the formula in P5 and then copy P5 from P6 tthru P45:

Sub gsnu()
Range("P5").Formula = "=(E5+F5)/G5"
Range("P5").Copy Range("P6:P45")
Range("P6:P45").NumberFormat = "0.00"
End Sub
--
Gary's Student


"crowdx42" wrote:

>
> Hi again,
> so I have recorded a macro where there are two cells being added
> together and divided by another cell value. This worked fine on several
> pages of the work book but now as I move through the book it is giving
> false results.
> Is there a problem with what was recorded?
> I have listed below and what I want the formula to do is add E+F and
> then divide by G and run through a column doing the same thing.
> What seems to be happening with the current macro is that it is getting
> stuck and is then returning the result for the first cell in the
> column.
> Any help welcome
> Patrick
>
> Range("P6").Select
> ActiveCell.FormulaR1C1 = "=SUM(RC[-11],RC[-10])/RC[-9]"
> Range("P6:P45").Select
> Selection.NumberFormat = "0.00"
>
>
> --
> crowdx42
> ------------------------------------------------------------------------
> crowdx42's Profile: http://www.excelforum.com/member.php...o&userid=37749
> View this thread: http://www.excelforum.com/showthread...hreadid=573513
>
>

[crowdx42]

I get the same result, the formula changes down the column BUT the result shows identical for each cell in the column. A way I have found that does get it to give the correct answer is to select the cell and then select and it then gives me the correct answer (this only works with my original formula and not with the suggested formula)
Any ideas?
Patrick

[Gord Dibben]

GS code works fine for me.

How about your Calculation Mode in Tools>Options>Calculation?

Auto or manual?


Gord Dibben MS Excel MVP

On Sun, 20 Aug 2006 13:41:38 -0400, crowdx42
<crowdx42.2cunp5_1156095908.9138@excelforum-nospam.com> wrote:

>
>I get the same result, the formula changes down the column BUT the
>result shows identical for each cell in the column. A way I have found
>that does get it to give the correct answer is to select the cell and
>then select and it then gives me the correct answer (this only works
>with my original formula and not with the suggested formula)
>Any ideas?
>Patrick

[crowdx42]

It is set as Manual and recalculate before save.
Thanks for the help
Patrick

[crowdx42]

Well nearing completion of this project I found the same thing is happening on another sheet when I excecute the same type of macro. This time I am doing a VLoopUP of a name on another sheet and then pulling a calculation on that sheet into the current sheet.
I get the exact same problem and the same workaround works here also.
Is this a bug in the code??
Patrick