Run-time error '1004': Application defined or Object defined error

I

ianweb

I am having difficulty with a run-time error '1004'.

Excel does not like it when I have substituted a variable
(linekount_I) for a relative cell address within a counta formula.

This generates the error:

ActiveCell.FormulaR1C1 = "=COUNTA(R[-linekount_I]C:R[-1]C) & ""
Invoice(s)"""

This works fine:

ActiveCell.FormulaR1C1 = "=COUNTA(R[-5]C:R[-1]C) & "" Invoice
(s)"""

I need to have the formula created with a varying number of rows. The
hard coded 5 will not suffice.

Any help would be appreciated
 
J

Jacob Skaria

The below code should work.

ActiveCell.FormulaR1C1 = "=COUNTA(R[-" & linekount_I & "]C:R[-1]C) & ""
Invoice(s)"""

If this post is helpful click Yes
 
J

Joel

from
ActiveCell.FormulaR1C1 = "=COUNTA(R[-linekount_I]C:R[-1]C) & ""

to
ActiveCell.FormulaR1C1 = "=COUNTA(R" & (-1 * linekount_I) & "C:R[-1]C)"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time Error '1004': Selection is too large. 0
Run Time Error 1004: Application or Object Defined Error 4
R1C1 Formula 1
Int Variable into R1C! Formula 1
Problem with formulae in VBA 2
#NAME? on correct formula 4
Max of a range help 4
Application-defined or object-defined error 2

Top