View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dean Corda Dean Corda is offline
external usenet poster
 
Posts: 2
Default 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.