Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula from VBA to Excel worksheet
How do I get this formula from VBA into a cell in an
Excell worksheet. Code first. sVSTid = Cells(lRaekke, 7).Address sHvis = "=+hvis($i$230;$i$23*" & sVSTid sVSLoen = Cells(lRaekke, 22).Address sEllers = ";" & sVSLoen & ")" sSumFormel = sHvis & sEllers Debug.Print sSumFormel It gives this formula: =+hvis($i$230;$i$23*$G$46;$V$46) (danish IF-function) It keeps failing me no matter what I do. So I must do something wrong. Please help me Lars Kofod |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Formula from one workbook/worksheet to another | Excel Worksheet Functions | |||
Formula for Excel Worksheet | Excel Worksheet Functions | |||
If Then Else Formula for Excel Worksheet | Excel Worksheet Functions | |||
How do I make formula in Excel from other worksheet? | Excel Worksheet Functions | |||
Display excel formula on worksheet | Excel Worksheet Functions |