Magical appearance of single quotes.
 

This line is used in my code:
Selection.FormulaR1C1 = "=COUNTIF(G2:G" & vDiff
& ",""Regular"")"

The problem is that somehow I get this on the worksheet:
=COUNTIF('G2':'G4',"Regular") <-- single quotes around the
elements of the range.

How can I write the line so the single quotes do not
appear?

Any help will be appreciated.

Dean.

Magical appearance of single quotes.
 

First, try deleting the R1C1 part of your code
BTW, you do NOT have to select to place the formula. You could use
range("b3").Formula = "=COUNTIF(G2:G" & vDiff & ",""Regular"")"

"Dean Corda" wrote in message
...
This line is used in my code:
Selection.FormulaR1C1 = "=COUNTIF(G2:G" & vDiff
& ",""Regular"")"

The problem is that somehow I get this on the worksheet:
=COUNTIF('G2':'G4',"Regular") <-- single quotes around the
elements of the range.

How can I write the line so the single quotes do not
appear?

Any help will be appreciated.

Dean.

Magical appearance of single quotes.
 

Thanks for the help, Don. I'm still waiting for this post
to show up in the web view...I used the search to find it.

-----Original Message-----
First, try deleting the R1C1 part of your code
BTW, you do NOT have to select to place the formula. You
could use
range("b3").Formula = "=COUNTIF(G2:G" & vDiff
& ",""Regular"")"

"Dean Corda" wrote in message
...
This line is used in my code:
Selection.FormulaR1C1 = "=COUNTIF(G2:G" & vDiff
& ",""Regular"")"

The problem is that somehow I get this on the worksheet:
=COUNTIF('G2':'G4',"Regular") <-- single quotes around
the
elements of the range.

How can I write the line so the single quotes do not
appear?

Any help will be appreciated.

Dean.


.