blanks in pivot
 

hi

i am creating a pivit table thru vba and i first see the
last column adn last used row and use that to create the
table,
but in one of the cases a sheet has 2500 lines (as per
used range) but inbetween it has blank lines.
whats happening is soem 2-3 line are used to total out
some 1500 lines and then after 2-3 line again the content
follows. so what happens due to this is that my pivot data
creates blank in the end!

is there any way i can avoid this????
i hope i have made my query clear...
thanks in advance