View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
igneramos[_3_] igneramos[_3_] is offline
external usenet poster
 
Posts: 1
Default 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/