Entering Array Formula

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

Guest

Hi

I am trying to enter the following an array formula in
VBA:

Rng.FormulaArray = "=sum((One = A1)*(Two = "Hello"))

One and Two are named ranges.

The problem is the quotation mark around the
word "Hello". VBA does not like it. How can I make VBA to
like it. One way would be to name the word and use the
name. But it is just bugging me that I can not enter it
directly. Thanks for your suggestions.
 
Hi

Quotes in strings are written as double quotes:

"=sum((One = A1)*(Two = ""Hello""))"

HTH. Best wishes Harald
 
You must log in or register to reply here.

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

copying an array formula 2
Retrieving the characters lost 3
Formula appearing as Value in Formula Bar 1
Calculate the result of an array in vba 1
Revert array formula using code 3
Brain lock: using array formula within VBA? 12
arrays 2
array values 4

Back
Top