Referencing Symbols in FormulaR1C1

[graphicgoose]

Hi,

Hopefully this is a nice easy one. I'm trying to insert a formula into a cell that is an AverageIF with the criteria that the cell contains "Average Δ". I've used ChrW(916) elsewhere in the macro to put this character into a cell, but I'm not sure how to then get VBA to input into a formula. This is what I have so far:

Please Login or Register  to view this content.

Running this puts the following formula into the cell:

Please Login or Register  to view this content.

What I would like the formula to read is:

Please Login or Register  to view this content.

Thanks,
Daniel

[Norie]

Try this.

Please Login or Register  to view this content.

[jewelsharma]

How about this:

1. store "Average Δ" as a string on any cell of your workbook. (Let's say Sheet2!A1)
2. assign this to a VBA variable
3. use the variable in your formula

Please Login or Register  to view this content.

HTH!

Edit: Or simply use what Guru Norie suggested.

[graphicgoose]

Perfect, Norie's solution worked a treat! Thanks.