| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
