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.