You will get #REF if ROWn does not exits.

Can you give an example of (say) row1 and "rngDataNums" (ranges and data)

"JzP" wrote:

On Jun 18, 10:55 am, Toppers
wrote:
Try:

=SUMPRODUCT(TRANSPOSE(INDIRECT("row"&ROW())*(rngDa taNums)))



"JzP" wrote:
Hi all,
For various complicated reasons I am using a macro to build a series
of "helper" named ranges which are named "Row" and then the row
number. (ie Row1, Row2 etc)
I can then use the following function in my worksheet;
=SUMPRODUCT(TRANSPOSE(Row1)*(rngDataNums)) and, if I enter it with
Ctrl-Shift-Enter, I get the correct value.

What I want to do is to replace the "Row1" in the formula above with
the equivalent of "Row" & Row() so each row will use the correct named
range previously built for that row.

However, can't work out the correct syntax.

Any help would be greatly appreciated.
TIA

John- Hide quoted text -

- Show quoted text -

Thanks Toppers,

Unfortunately that gives a "#REF" error.

John