VAB problem in Excell:

I have a worksheet that is importing data from a variable length text file. after the import I need to append another line of data from another worksheet directly at the end of the list. My problem is that blank lines are appearing at the bottom ofthe first import. I need to delete these lines. I found some code to delete blank lines but it does not work. I beleive this is because the values in the cells are nulls (not blank)?. If I run the first import delete the blank lines at the bottom of the worksheet I imported into and then run the second part that appends the trailer to the bottom it works fine.
can any one point me in the right direction so I can finish this project?