Do you want to include that cell in the range?

Are there any other types of errors in the range like #N/A, #NUM!, #DIV/0! ?

Try something like this:

=Sheet1!$A$1:INDEX(Sheet1!$A:$A,MATCH(TRUE,ISERROR (Sheet1!$A$1:$A$20),0))

--
Biff
Microsoft Excel MVP


"chg" wrote in message
...
I want to define a named Range up to the first cell in a column that
has a #value error.
How could i find that cell?
Any ideas

Thx-