alktrigger
Aimless Extraordinaire
- Local time
- Today, 13:50
- Joined
- Jun 9, 2009
- Messages
- 124
i'm trying to automate the excel function =COUNTIF(D248, "> 0") in my vb code, but how do I work around the quotation marks in the criteria field?
Code:
strCell2 = "= COUNTIF(" & strChar(o)& "2:"& strChar(o) & (intRecordNumber - 1) & ", [COLOR=Red]"> 0"[/COLOR] )"