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

Quote within quotes: two quotes

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Maarkr" wrote in message
...
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