http://www.cpearson.com/excel/deleti...eleteBlankRows

--
Kind regards,

Niek Otten

"nabil" wrote in message
...
I am using Excel 2003 Visual Basic Programming to try to improve my work .
I
have an excel sheet with two coloumns, one coloumn contains nanes of
companies, named first coloumn, and the other, the secomd colomun
containes a
modified list of the companies with new companies added randmoly in the
second coloumn . I used the the VLOOKUP function to compare between two
lists of companies names in different coloumns and find out the new
company
name which appears in the second coloumn an not exist in the first , then
I
wrot a VB code to put the new company names under the names in the first
coloumn.So, the first coloumn shall contain the new company names at the
end
of the coloumn besides old company names that it already exist.
The problem is that the new names which appears in the first coloumn due
to
to VB code are in scattered rows, i.e, the first coloumn now has many
blank
rows(or cells) seperating the new company names generateg by VB code.
My Question is How to remove blank rows (or cells) that appears in the
first coloumn?
using suitable VB code?