Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with formula in VBA
Hi, I get an error when I put this line of code in VBA (I'm using th Italian version of Excel). I noticed that when I put more complex formulas I got errors. Dim mystring as string Dim firstfreepos as integer mystring = "=SE(C" & firstFreePos & ";C" & firstFreePos & "-B" firstFreePos & ";OGGI()-B" & firstFreePos & ") " Range("D" & firstFreePos).Formula = (mystring) I got no errors removing the '=' symbol from the beginning of th formula. If anyone can help me, it would really be appreciated. Thanks. Andre ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with formula in VBA
Hi nagar
Excel VBA is US-centric, so you need to either use the US-English version of the formulas (including US separators), or use .FormulaLocal instead of ..Formula (which will only then work with Italian settings). Regards Stephen Bullen "nagar" wrote in message ... Hi, I get an error when I put this line of code in VBA (I'm using the Italian version of Excel). I noticed that when I put more complex formulas I got errors. Dim mystring as string Dim firstfreepos as integer mystring = "=SE(C" & firstFreePos & ";C" & firstFreePos & "-B" & firstFreePos & ";OGGI()-B" & firstFreePos & ") " Range("D" & firstFreePos).Formula = (mystring) I got no errors removing the '=' symbol from the beginning of the formula. If anyone can help me, it would really be appreciated. Thanks. Andrea ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem | Excel Worksheet Functions | |||
Formula problem | Excel Discussion (Misc queries) | |||
Formula problem | Excel Discussion (Misc queries) | |||
problem with formula | Excel Discussion (Misc queries) | |||
formula problem | Excel Discussion (Misc queries) |