EZ?- Trying to insert a simple formula using VB

[Maarkr]

I need to code some stuff in Excel before I import it into Access... I can
code vb in Access but get mixed up in Excel:

I want to insert a formula in a cell, but it doesn't like the parens around
unit summary:

Range("O1").Formula = "=COUNTA(A13:A100) -COUNTIF(E13:E100,"Unit Summary")"

Seemed like there were other examples on this site of using "" in a formula
or value? I tried no parens (returns 0 for countif) and tried '. Thx

 

[Niek Otten]

Range("O1").Formula = "=COUNTA(A13:A100) -COUNTIF(E13:E100,""Unit
Summary"")"

Quote within quotes: two quotes

 

[Jacob Skaria]

Try the below (in one line)

Range("O1").Formula = "=COUNTA(A13:A100) -COUNTIF(E13:E100,""Unit Summary"")"

If this post helps click Yes

 

[Maarkr]

so Excel uses dbl quotes instead of single quotes... not like access vb.
Verrrry interesting.