Macro =sum function not working correctly
 

Hi again,
so I have recorded a macro where there are two cells being adde
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 an
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 gettin
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

Macro =sum function not working correctly
 

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

Macro =sum function not working correctly
 

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

--
crowdx4
-----------------------------------------------------------------------
crowdx42's Profile: http://www.excelforum.com/member.php...fo&userid=3774
View this thread: http://www.excelforum.com/showthread.php?threadid=57351

Macro =sum function not working correctly
 

GS code works fine for me.

How about your Calculation Mode in ToolsOptionsCalculation?

Auto or manual?


Gord Dibben MS Excel MVP

On Sun, 20 Aug 2006 13:41:38 -0400, crowdx42
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

Macro =sum function not working correctly
 

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


--
crowdx42
------------------------------------------------------------------------
crowdx42's Profile: http://www.excelforum.com/member.php...o&userid=37749
View this thread: http://www.excelforum.com/showthread...hreadid=573513

Macro =sum function not working correctly
 

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:confused:


--
crowdx42
------------------------------------------------------------------------
crowdx42's Profile: http://www.excelforum.com/member.php...o&userid=37749
View this thread: http://www.excelforum.com/showthread...hreadid=573513