I've got a SUMIF formula in my macro code (see below) and need to specify a
range to include the 'nrows' (I have defined all of the bits in this formula
at the top of my code) but am having trouble with this...

Cells (nIrws, 21).Formula = "=SUMIF(G2:G nIRows,""<>CR"",U2:U nIRows)"

Any ideas? Would this work??