Excel - SQLREQUEST - #N/A
 

I have a block of cells that contain {=SQL.REQUEST($A$5,,,$A$6)}.

Since I don't know how many records will be returned, I have more rows
than I think would ever be returned that contain this array formula
statement.

The rows below the end of the data contain #N/A.

Is there any method to eliminate the #N/A or the formulae in these
cells?

I'd like for the block of data to contract or expand based on the
number of records returned by the SQLREQUEST funtion. Any ideas?

Thanks, Mark

Excel - SQLREQUEST - #N/A
 

Mark

You can use conditional formatting to hide those NAs. Select the whole
range, say it starts in A1, and choose Format - Conditional Formatting.
Enter Formula Is and =ISERROR(A1), then change the text color to match the
cell color.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Mark" wrote in message
om...
I have a block of cells that contain {=SQL.REQUEST($A$5,,,$A$6)}.

Since I don't know how many records will be returned, I have more rows
than I think would ever be returned that contain this array formula
statement.

The rows below the end of the data contain #N/A.

Is there any method to eliminate the #N/A or the formulae in these
cells?

I'd like for the block of data to contract or expand based on the
number of records returned by the SQLREQUEST funtion. Any ideas?

Thanks, Mark

Excel - SQLREQUEST - #N/A
 

SQL.Request can't show more then ~8000 cells at once
Try to make an another file with your query results with the SELECT .... INTO copiedTable FROM ..