Bad QueryTable Row Count

  • Thread starter Thread starter igneramos
  • Start date Start date
I

igneramos

Is there a way to get the record count from a query attached to a query
table other than to look at querytable.resultrange.rows.count?

the reason I ask is because if the query returns 0 records,
querytable.resultrange.rows.count returns a value of 3. Obviously not
correct. Doesn't matter if the QueryTable is set to display field
names, either.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

QueryTables, some basic questions 5
Question on Deleting Querytables 3
Need Help with Refreshing Querytables. 8
Connecting Questions on Querytables 1
listobjects and querytables 0
how delete old querytables? 2
How to obtain the row count of a QueryTable from a Web query 4
Create muliple sheets using querytable 6

Back
Top