Perhaps the issue is the hyphens in the name you give the range?

"Timmy Mac1" wrote:


Tearing my hair out here.

I have a spreadsheet operating with a number of worksheets. On one of
the worksheets I have highlighted a table of data and using INSERT -
NAME - CREATE option, used the labels on the top of the columns.

My problem is that when I go to use one of the names in a sumproduct on
another sheet, its as if it doesn't exist!

When I insert a new worksheet and use it to paste a list of the names
I'm using, it misses out the names pertinent to three or four of the
column names.

However, when I'm on the sheet itself, it shows the name I need for my
formula and lists it when I paste the names. It also shows it in the
name box when I highlight the range.

There appears to be nothing untoward about the names I'm using. For
example the one I need is -IssuingPolicyNo- with no spaces before or
after it.

Does anyone know why this is happening? It's driving me nuts!


--
Timmy Mac1
------------------------------------------------------------------------
Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188
View this thread: http://www.excelforum.com/showthread...hreadid=573060