Thread: Query not returning all the rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
  
Posts: 2,452
Default Query not returning all the rows
Could you post the relevant code?
Did you use an Integer variable somewhere?

RBS


"barnabel" wrote in message
...
I have Excel 2007 which is supposed to support sheets longer than 65K rows.

I have a query that should return more than 135K rows. But there are only
65K rows in the sheet. Anybody know how to set the maximum number of rows
returns?

Reply With QuoteReply With Quote