Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the query range
Hello All
I run a database query from Excel that populates data starting at D11 as follows: Range("D11").Select Selection.QueryTable.Refresh BackgroundQuery:=False Now I want to know what range of cells in the worksheet have been populated by the query how can we find it ?. I looked for various functions on the QueryTable I cannot find any information on how to obtain the Worksheet range that the QueryTable as populated can you please let me know how I can find the worksheet range populated by the QueryTable. Thanks Belinda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding the Access query a pivot table is based on | Excel Discussion (Misc queries) | |||
finding a value between a range | Excel Worksheet Functions | |||
Excel not finding the server in web query | Excel Discussion (Misc queries) | |||
finding name within range | Excel Worksheet Functions | |||
finding if name within range | Excel Worksheet Functions |