Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
This one is HARD! :(
Hi,
I've problem with VBA & excel: main idea of this is: in sql database i have mountly accounts balance on sheet1 i have formula fex. (#123..199) its mean that i have to add balance for accounts from 123 to 199 sometimes formula look like that : ((#120)+(#130..150)-(#155))*0,5 on sheet2 I create table for result of this formula on every mount i do connection to database, get all static (#120) and range (#130..150) values and put it in to values, so this values can look like this: string value FJan = ((-85)+((45)+(-3))+(123))*0,5 for january string value FFeb = ((10)+((-50)+(-3))+(0))*0,5 for febuary on sheet1.B5 if have: X2+X30 it means that I have to add values from sheet2.B2+sheet2.B3 for January (sheet2.C2+sheet2.C3 for Febuary) and check if its 0 if yes than put value in to cell on sheet2 from FJan I have problem with IIf in VBA for January: Sheet2.Cells(1,3).Value = IIf(Val(Replace(Sheet1.Cells(2,5), "X", "B")), "="& FJan, 0) for Febuary: Sheet2.Cells(2,3).Value = IIf(Val(Replace(Sheet1.Cells(2,5), "X", "C")), "="& FFeb, 0) i get false everytime Val(Replace(Sheet1.Cells(2,5), "X", "B")) isnt boolean it could be the problem Can anyone have me with this, please Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Too hard to do? | Charts and Charting in Excel | |||
Maybe too hard to do? | Excel Worksheet Functions | |||
I think this is a hard one | Excel Programming | |||
This is a hard one... | Excel Discussion (Misc queries) |