|
Formula problem
In a Microsoft Visual Basic for Applications macro (Excel
2000), when I attempt to put a formula in a cell in some cases I receive the following run-time error: Run-time error '1004': Application-defined or object-defined error For example, the first 3 statements bellow works fine, but the 4TH doesn't: .. .. .. Worksheets("Radni nalog").Range("F3").Formula = "='Planska kalkulacija'!F3:G3" Worksheets("Radni nalog").Range("H6:Q6").Formula = "='Planska kalkulacija'!H6:Q6" Worksheets("Radni nalog").Range("AF6").Formula = "='Planska kalkulacija'!Y6" 'The next statement doesn't works: Worksheets("Radni nalog").Range("AC19").Formula = _ "=PRODUCT('Ostvareni indirektni troskovi'! T12;'Radni nalog'!AC13)/ _ OFFSET('Ostvareni direktni troskovi'! P10;+'Osnovni podaci'!R8;0;1;1)" .. .. .. If I remove the equal sign from the beginning of the formula, the formula will be placed to the cell!(Of course, it has no sense without =) Could anyone help me? |
Formula problem
Hi
try replacing the semicolon: =PRODUCT('Ostvareni indirektni troskovi'!T12,'Radni nalog'!AC13)/OFFSET('Ostvareni direktni troskovi'!P10,'Osnovni podaci'!R8,0,1,1)" -- Regards Frank Kabel Frankfurt, Germany Matyas wrote: In a Microsoft Visual Basic for Applications macro (Excel 2000), when I attempt to put a formula in a cell in some cases I receive the following run-time error: Run-time error '1004': Application-defined or object-defined error For example, the first 3 statements bellow works fine, but the 4TH doesn't: . . . Worksheets("Radni nalog").Range("F3").Formula = "='Planska kalkulacija'!F3:G3" Worksheets("Radni nalog").Range("H6:Q6").Formula = "='Planska kalkulacija'!H6:Q6" Worksheets("Radni nalog").Range("AF6").Formula = "='Planska kalkulacija'!Y6" 'The next statement doesn't works: Worksheets("Radni nalog").Range("AC19").Formula = _ "=PRODUCT('Ostvareni indirektni troskovi'! T12;'Radni nalog'!AC13)/ _ OFFSET('Ostvareni direktni troskovi'! P10;+'Osnovni podaci'!R8;0;1;1)" . . . If I remove the equal sign from the beginning of the formula, the formula will be placed to the cell!(Of course, it has no sense without =) Could anyone help me? |
Formula problem
You can't put line continuation characters within a string
Worksheets("Radni nalog").Range("AC19").Formula = _ "=PRODUCT('Ostvareni indirektni troskovi'!" & _ "T12;'Radni nalog'!AC13)/" & _ "OFFSET('Ostvareni direktni troskovi'!" & _ "P10;+'Osnovni podaci'!R8;0;1;1)" Should work. -- Regards, Tom Ogilvy "Matyas" wrote in message ... In a Microsoft Visual Basic for Applications macro (Excel 2000), when I attempt to put a formula in a cell in some cases I receive the following run-time error: Run-time error '1004': Application-defined or object-defined error For example, the first 3 statements bellow works fine, but the 4TH doesn't: . . . Worksheets("Radni nalog").Range("F3").Formula = "='Planska kalkulacija'!F3:G3" Worksheets("Radni nalog").Range("H6:Q6").Formula = "='Planska kalkulacija'!H6:Q6" Worksheets("Radni nalog").Range("AF6").Formula = "='Planska kalkulacija'!Y6" 'The next statement doesn't works: Worksheets("Radni nalog").Range("AC19").Formula = _ "=PRODUCT('Ostvareni indirektni troskovi'! T12;'Radni nalog'!AC13)/ _ OFFSET('Ostvareni direktni troskovi'! P10;+'Osnovni podaci'!R8;0;1;1)" . . . If I remove the equal sign from the beginning of the formula, the formula will be placed to the cell!(Of course, it has no sense without =) Could anyone help me? |
Formula problem
Hi!
It works!!!!!! Danke schön!!!!!! -----Original Message----- Hi try replacing the semicolon: =PRODUCT('Ostvareni indirektni troskovi'!T12,'Radni nalog'!AC13)/OFFSET('Ostvareni direktni troskovi'! P10,'Osnovni podaci'!R8,0,1,1)" -- Regards Frank Kabel Frankfurt, Germany Matyas wrote: In a Microsoft Visual Basic for Applications macro (Excel 2000), when I attempt to put a formula in a cell in some cases I receive the following run-time error: Run-time error '1004': Application-defined or object-defined error For example, the first 3 statements bellow works fine, but the 4TH doesn't: . . . Worksheets("Radni nalog").Range("F3").Formula = "='Planska kalkulacija'!F3:G3" Worksheets("Radni nalog").Range("H6:Q6").Formula = "='Planska kalkulacija'!H6:Q6" Worksheets("Radni nalog").Range("AF6").Formula = "='Planska kalkulacija'!Y6" 'The next statement doesn't works: Worksheets("Radni nalog").Range("AC19").Formula = _ "=PRODUCT('Ostvareni indirektni troskovi'! T12;'Radni nalog'!AC13)/ _ OFFSET('Ostvareni direktni troskovi'! P10;+'Osnovni podaci'!R8;0;1;1)" . . . If I remove the equal sign from the beginning of the formula, the formula will be placed to the cell!(Of course, it has no sense without =) Could anyone help me? . |
Formula problem
Hi!
The original line in code wasn't broken, so the solution is what Frank Kabel wrote. Thanks anyway! Regards, Matyas -----Original Message----- You can't put line continuation characters within a string Worksheets("Radni nalog").Range("AC19").Formula = _ "=PRODUCT('Ostvareni indirektni troskovi'!" & _ "T12;'Radni nalog'!AC13)/" & _ "OFFSET('Ostvareni direktni troskovi'!" & _ "P10;+'Osnovni podaci'!R8;0;1;1)" Should work. -- Regards, Tom Ogilvy "Matyas" wrote in message ... In a Microsoft Visual Basic for Applications macro (Excel 2000), when I attempt to put a formula in a cell in some cases I receive the following run-time error: Run-time error '1004': Application-defined or object-defined error For example, the first 3 statements bellow works fine, but the 4TH doesn't: . . . Worksheets("Radni nalog").Range("F3").Formula = "='Planska kalkulacija'!F3:G3" Worksheets("Radni nalog").Range("H6:Q6").Formula = "='Planska kalkulacija'!H6:Q6" Worksheets("Radni nalog").Range("AF6").Formula = "='Planska kalkulacija'!Y6" 'The next statement doesn't works: Worksheets("Radni nalog").Range("AC19").Formula = _ "=PRODUCT('Ostvareni indirektni troskovi'! T12;'Radni nalog'!AC13)/ _ OFFSET('Ostvareni direktni troskovi'! P10;+'Osnovni podaci'!R8;0;1;1)" . . . If I remove the equal sign from the beginning of the formula, the formula will be placed to the cell!(Of course, it has no sense without =) Could anyone help me? . |
Formula problem
The original line in code wasn't broken, so the solution
is what Frank Kabel wrote. Thanks anyway! It certainly was in what you posted: From your post: "=PRODUCT('Ostvareni indirektni troskovi'!T12;'Radni nalog'!AC13)/ _ see the continuation character inside a quoted string. If you don't past the actual code, then it is a crap shoot. Also, if that fixed the actual code, then you don't need to replace the semicolon if you use FormulaLocal rather than Formula, so Frank's is one solution among many. -- Regards, Tom Ogilvy "Matyas Kormendy" wrote in message ... Hi! The original line in code wasn't broken, so the solution is what Frank Kabel wrote. Thanks anyway! Regards, Matyas -----Original Message----- You can't put line continuation characters within a string Worksheets("Radni nalog").Range("AC19").Formula = _ "=PRODUCT('Ostvareni indirektni troskovi'!" & _ "T12;'Radni nalog'!AC13)/" & _ "OFFSET('Ostvareni direktni troskovi'!" & _ "P10;+'Osnovni podaci'!R8;0;1;1)" Should work. -- Regards, Tom Ogilvy "Matyas" wrote in message ... In a Microsoft Visual Basic for Applications macro (Excel 2000), when I attempt to put a formula in a cell in some cases I receive the following run-time error: Run-time error '1004': Application-defined or object-defined error For example, the first 3 statements bellow works fine, but the 4TH doesn't: . . . Worksheets("Radni nalog").Range("F3").Formula = "='Planska kalkulacija'!F3:G3" Worksheets("Radni nalog").Range("H6:Q6").Formula = "='Planska kalkulacija'!H6:Q6" Worksheets("Radni nalog").Range("AF6").Formula = "='Planska kalkulacija'!Y6" 'The next statement doesn't works: Worksheets("Radni nalog").Range("AC19").Formula = _ "=PRODUCT('Ostvareni indirektni troskovi'! T12;'Radni nalog'!AC13)/ _ OFFSET('Ostvareni direktni troskovi'! P10;+'Osnovni podaci'!R8;0;1;1)" . . . If I remove the equal sign from the beginning of the formula, the formula will be placed to the cell!(Of course, it has no sense without =) Could anyone help me? . |
| All times are GMT +1. The time now is 05:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com