how to place formula to cell
 

people, my task is to place to cells a formula

for example

for vv = 1 to 10
.cells(vv,2).formula = "=if(sum(XX:XX)=160;2,3)"

next



when i try to assign a formula to a cell, i get the erorr,
why ??


can anybody help ????]

thank

--
Mare
-----------------------------------------------------------------------
Marek's Profile: http://www.excelforum.com/member.php...fo&userid=1376
View this thread: http://www.excelforum.com/showthread.php?threadid=26516

how to place formula to cell
 

Hi Marek,

Changing to:

cells(vv,2).formula = "=if(sum(XX:XX)=160;2,3)"

to

cells(vv,2).formula = "=if(sum(XX:XX)=160,2,3)"

worked for me.

I changed the semicolon after 160 to a comma.


---
Regards,
Norman



"Marek" wrote in message
...

people, my task is to place to cells a formula

for example

for vv = 1 to 10
cells(vv,2).formula = "=if(sum(XX:XX)=160;2,3)"

next



when i try to assign a formula to a cell, i get the erorr,
why ??


can anybody help ????]

thanks


--
Marek
------------------------------------------------------------------------
Marek's Profile:
http://www.excelforum.com/member.php...o&userid=13769
View this thread: http://www.excelforum.com/showthread...hreadid=265164

how to place formula to cell
 

Sub InsertFormula()
Dim vv As Integer
With Application
..ScreenUpdating = False
..Calculation = xlCalculationManual
For vv = 1 To 10
Cells(vv, 2).Formula = _
"=IF(SUM(C1:C10)=160,2,3)"
Next
..ScreenUpdating = True
..Calculation = xlCalculationAutomatic
End With
End Sub

---
HTH
Jason
Atlanta, GA

-----Original Message-----

people, my task is to place to cells a formula

for example

for vv = 1 to 10
.cells(vv,2).formula = "=if(sum(XX:XX)=160;2,3)"

next



when i try to assign a formula to a cell, i get the
erorr,
why ??


can anybody help ????]

thanks


--
Marek
---------------------------------------------------------
---------------
Marek's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=13769
View this thread:
http://www.excelforum.com/showthread...hreadid=265164

.

how to place formula to cell
 

Not sure where that second dot came from. Should be "."
not ".." in the code.

Jason

-----Original Message-----
Sub InsertFormula()
Dim vv As Integer
With Application
..ScreenUpdating = False
..Calculation = xlCalculationManual
For vv = 1 To 10
Cells(vv, 2).Formula = _
"=IF(SUM(C1:C10)=160,2,3)"
Next
..ScreenUpdating = True
..Calculation = xlCalculationAutomatic
End With
End Sub

---
HTH
Jason
Atlanta, GA

-----Original Message-----

people, my task is to place to cells a formula

for example

for vv = 1 to 10
.cells(vv,2).formula = "=if(sum(XX:XX)=160;2,3)"

next



when i try to assign a formula to a cell, i get the
erorr,
why ??


can anybody help ????]

thanks


--
Marek
--------------------------------------------------------
-
---------------
Marek's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=13769
View this thread:
http://www.excelforum.com/showthread...hreadid=265164

.

.