Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 .. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sqlrequest only return one value | Excel Worksheet Functions | |||
sqlrequest in excel 2003 | Excel Worksheet Functions |