Formula problem

  • Thread starter Thread starter Matyas
  • Start date Start date
M

Matyas

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?
 
Hi
try replacing the semicolon:
=PRODUCT('Ostvareni indirektni troskovi'!T12,'Radni
nalog'!AC13)/OFFSET('Ostvareni direktni troskovi'!P10,'Osnovni
podaci'!R8,0,1,1)"
 
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.
 
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


.
Click to expand...
 
Hi!

The original line in code wasn't broken, so the solution
is what Frank Kabel wrote.
Thanks anyway!

Regards, Matyas
 
The original line in code wasn't broken, so the solution
is what Frank Kabel wrote.
Thanks anyway!
Click to expand...


It certainly was in what you posted: From your post:
"=PRODUCT('Ostvareni indirektni troskovi'!T12;'Radni nalog'!AC13)/ _
Click to expand...

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.
 
Back
Top