Magical appearance of single quotes.

  • Thread starter Thread starter Dean Corda
  • Start date Start date
D

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.
 
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"")"
 
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.
 
Back
Top