View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
macropod[_6_] macropod[_6_] is offline
external usenet poster
 
Posts: 14
Default 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!!