Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to I use nested quotation marks for 'SUMIF' function in Excel.
I'm writing a macro, creating a formula for an active cell using "SUMIF". I
need to use cell references that I can control via variables (aka 'cells' with rownum and colnum notations, or named cell ranges derived from same). Syntactically VBasic doesn't understand nested quotation marks for named cell ranges. Additionally using 'Range(Cells..' gives compile errors. Is it possible to accomplish this? Sample code?? Most grateful for help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When do I use quotation marks in an Excel formula? | Excel Worksheet Functions | |||
how do i add quotation marks to every item in a column in excel | Excel Discussion (Misc queries) | |||
How to stop Excel from inserting quotation marks into TXT files | Excel Discussion (Misc queries) | |||
Finding Quotation marks in Search function | Excel Worksheet Functions | |||
Excel Quotation Marks! | Excel Discussion (Misc queries) |