how to remove blank rows from a sheet using visual basic sode
 

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?

how to remove blank rows from a sheet using visual basic sode
 

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?