Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.Formula Property returning or setting inconsistent results?
Hi All - I have two sections of code; one to handle credits, and therefore
the formula includes "+" signs, and the other to handle debits, and the formula includes "-" signs. The code for the Credits works fine and returns a proper formatted formula line in all cases (that begins with an "=" sign). The code for Debits never includes the "=" sign at the beginning of any return strings. Can anyone spot why? Credit Code: wsDST.Cells(InFundFirstMtyRow, iColCnt).Formula = _ CStr(wsDST.Cells(InFundFirstMtyRow, iColCnt).Formula) & "+" & _ CStr(wsSRC.Cells(iRowCnt, "E").Formula) Above returns strings like "=4357.76+2345.65" Debit Code: wsDST.Cells(OutFundFirstMtyRow, iColCnt).Formula = _ CStr(wsDST.Cells(OutFundFirstMtyRow, iColCnt).Formula) & "-" & _ CStr(wsSRC.Cells(iRowCnt, "D").Formula) Above returns string like "4357.76-2345.65" Thanks Much :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning zero if the results of a formula is a negative number? | Excel Discussion (Misc queries) | |||
Formula results inconsistent. | Excel Worksheet Functions | |||
Array formula returning wrong results | Excel Discussion (Misc queries) | |||
Setting the formula property of a textbox | Excel Programming | |||
setting formula property | Excel Programming |