I have 100 rows of information in an excel file bu there are about 200 or so
blank lines. does any one know the code that I can use to load the
information into an array less the blank lines the place them into a
different area of the worksheet

Thanks

--
Helping Is always a good thing