| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a formula place a value in another cell | Excel Discussion (Misc queries) | |||
| I want to place a checkbox in the middle of a cell, yet I want thecheckboxArea take up the entire cell. | Excel Discussion (Misc queries) | |||
| Automatically place text in one cell into cell in another sheet | New Users to Excel | |||
| Can I place a formula/cell reference in the Header/footer Excel | Excel Worksheet Functions | |||
| Is there a formula that will place the sheet name in a cell? | Excel Worksheet Functions | |||
Hybrid Mode
