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