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)"

--
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?

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?

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?

.

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?



.

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?



.