I'm trying to put an Excel formula into a particular cell using programming,
how do I do quotation marks?

formula might read something like:
=countif(A2:A100,"<100")

I have had to use work arounds, like storing part of the data in a cell, and
referencing it that way.
=countif(A2:A100, B1)
Where I have already stored the string <100 in B1.

Or I suppose I could write my own function and remove the parenthesis, was
just trying to see if there was a shortcut before proceeding.

Thanks,
John