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
>
>