Bad QueryTable Row Count
 

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.


---
Message posted from http://www.ExcelForum.com/