Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Double Quotations
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Double Quotations
Hi John,
Try: ActiveCell.FormulaR1C1 = _ "=COUNTIF(R[-5]C[-3]:R[93]C[-3],""<100"")" --- Regards, Norman "John Viall" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding quotations / brackets | Excel Worksheet Functions | |||
Inserting Quotations | Excel Discussion (Misc queries) | |||
template for quotations in excel | Excel Discussion (Misc queries) | |||
Quotations and blanks cells (that aren't)... | Excel Worksheet Functions | |||
quotations form | Excel Worksheet Functions |