Magical appearance of single quotes.

[Dean Corda]

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.

 

[Don Guillett]

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]

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.