Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Querying a Dynamic Range in Excel

Status
Not open for further replies.
travisbrown

travisbrown

Technical User
Dec 31, 2001
1,016
When querying a named range in Excel using Jet.4.0 I can retrieve info just fine. If I change the range to a dynamic range, I get an error message saying the object cannot be found.

Does anyone know how to query a dynamic range in Excel?
 
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Wrong code in a href ?
Replies
1
Views
189
leifoet
leifoet
penguinspeaks
  • Locked
  • Question
Parse a database field that is comma delimited and input the results into another table
Replies
0
Views
184
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
How to check if a datatable is empty ?
Replies
0
Views
200
leifoet
leifoet
DiDYRO_
  • Locked
  • Question
How do I make a VBS file that can collect dialog-type answers in a local .log file?
Replies
0
Views
169
DiDYRO_
DiDYRO_
penguinspeaks
  • Locked
  • Question
Start loop from a specified point
Replies
0
Views
161
penguinspeaks
penguinspeaks

Part and Inventory Search

Sponsor

Back
Top