How to I use nested quotation marks for 'SUMIF' function in Excel.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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.
 
Hi Glen,

You can insert them via Chr(34). For example:
Cell.Formula = "SUMIF(A1:A10" & Chr(34) & ">0" & Chr(34) & ")"

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Entering quote marks in SUMIF function 2
Using variables in macro functions 2
formula strings containing quotation marks - VBA 5
Quotation marks within a formula 4
How to insert a page break in Excel VBA 8
How to use Sumifs with vertically and horizontally criterias 3
how to recycle through cells in a selected range 2
Code to Assist with Nested Function, Also Using ISERROR 2

Back
Top