Inserting ">","<" etc. in a formula

[owainl]

Hi, I'm trying to write some code that inserts a SUMIF function to a given range of cells:

In simplified form, the code runs as follows:

Please Login or Register  to view this content.

The problem is with the ""<"" bit as VBA keeps interpreting it as "" is less than "", thus returning FALSE in cell A1 instead of the function. How do I sort this out?

[royUK]

What is the actual formula?

If you are using VBA, do you need the formula or just the result?

[owainl]

The actual formula is:

Please Login or Register  to view this content.

I don't mind just having the result but I can't really be bothered to write the code. I'd quite like to know - for future reference - how to insert symbols such as '<', '>', '<>', '<=', '>=' into formula without VBA getting confused...

[royUK]

That's not the formula as it appears in the cell which is what I asked for.

You can't enter a formula with VBA references in it

[owainl]

Oh, ok. Sorry - my mistake. The formula is to be inserted in a number of cells and is dynamic but the formula in the first cell ought to be:

=SUMIF(G3:G65,"<" &J69,K3:K65)

[royUK]

Why not use dynamic named ranges for ranges? If you use that formula in VBA then the ranges will change according to where you place the formula unless you have absolute references.

[owainl]

I want the ranges to change for each cell (except for the sumif range which will always be the G column - see the VBA code above). The formula works fine except that I can't get VBA to recognise the "is less than" (<) sign as being part of the formula.

[royUK]

See if this helps

Please Login or Register  to view this content.

[owainl]

Thanks - although I haven't used your answer, the ",""<""" part now works in my formula.

[royUK]

At least you saw how to use the <. Please mark the thread solved.