EZ?- Trying to insert a simple formula using VB
 

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

EZ?- Trying to insert a simple formula using VB
 

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

EZ?- Trying to insert a simple formula using VB
 

Try the below (in one line)

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

If this post helps click Yes
---------------
Jacob Skaria


"Maarkr" wrote:

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

EZ?- Trying to insert a simple formula using VB
 

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

"Maarkr" wrote:

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