Hi,

That is correct, It will not works if there are blank cells. Also, as a
best practise, please avoid leaving rows. columns or cells blank. If there
is any such blank, please type DUMMY else you could face problems with
sorting, filtering and pivoting.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

wrote in message
...
I am running query in a another system where the numbers of rows can
be 15 as well as 35000. I have tried the "supersize" method but it
does not function when the cells are empty... any ideas???