Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query database results in a named range
Good day.
Worksheet "A" has a working VLOOKUP to a named range in worksheet "B". However, after adding a query of an MS SQL database to retrieve fresh data, that VLOOKUP returns "#N/A". I have placed the query results in another range on worksheet "B" and jumped through all sorts of hoops to "place" that data in the previosuly named range, but cannot get past the "#N/A". Any suggestions are greatly appreciated. Thank you. -- Chuck Buchanan Special Projects Coordinator |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query database results in a named range
Chuck:
Assume you have a named range called "ImporData" and a querytables item 1 (default item number). This will set the named range to the range address of the querry reslults. ActiveWorkbook.Names("ImportedData").RefersTo = ActiveSheet.QueryTables(1).resultrange.name Good Luck -- Stewart Rogers DataSort Software, L.C. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel query and link named range | Links and Linking in Excel | |||
How Do I Query a Named Range | Excel Worksheet Functions | |||
sum of a named range with values based on vlookup results | Excel Worksheet Functions | |||
prevent duplicate results (database query) | Excel Programming | |||
help in showing results of database query | Excel Programming |