Thread: Run-time error '1004': Application defined or Object defined error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Run-time error '1004': Application defined or Object defined error
The below code should work.

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

If this post is helpful click Yes
---------------
Jacob Skaria
Reply With QuoteReply With Quote