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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to I use nested quotation marks for 'SUMIF' function in Excel.
Hi Glenn,
Not sure if this will help, but here sample code that I used to insert a formula. Cells(RowCount, 4) = "=sum(D" & RowAnchor & ":D" & RowCount - 1 & ")" RowCount and RowAnchor are variables I used. "Glenn" wrote: 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!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to I use nested quotation marks for 'SUMIF' function in Excel.
Hi Glen,
You can insert them via Chr(34). For example: Cell.Formula = "SUMIF(A1:A10" & Chr(34) & "0" & Chr(34) & ")" Cheers "Glenn" wrote in message ... 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!! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to I use nested quotation marks for 'SUMIF' function in Excel.
|
Reply |
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) |