You could select manually if as your example.

If #N/A would be random try DataFilterAutofilterCustomNot equal to......#N/A

The do what you want with visible cells.

I would suggest your trap for the #N/A errors and eliminate them at source by
leaving them look blank

Example only...........

=IF(ISNA(VLOOKUP(G7,$D$7:$F$23,2,FALSE)),"",VLOOKU P(G7,$D$7:$F$23,2,FALSE))

The when you sort they will fall to bottom.


Gord Dibben MS Excel MVP

On Wed, 31 Oct 2007 12:16:04 -0700, BZeyger
wrote:

I have an excel worksheet that contains various information. It mainly has 3
columns. The first Column is the Title, the second is the Year, and the third
is the Total (which comes from a different sheet).

After I have my infromation in the sheet, I sort it by the total column.
Some of the values are #N/A. I would like to selct the rows and columns up to
the #N/A.

For example:

The Worksheet:

A B C
1 Title1 2007 $58.95
2 Title2 2007 $75.25
3 Title3 2007 $38.66
4 Title4 2007 #N/A
5 Title5 2007 #N/A
6 Title6 2007 #N/A

In this example I would like to select A:1 thru C:3