Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete rows in visual basic | Excel Discussion (Misc queries) | |||
How to delete rows in visual basic | Excel Discussion (Misc queries) | |||
Visual Basic - Variable Sheet Names | Excel Discussion (Misc queries) | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
Visual Basic code to find next available (blank) row in a spreadsh | Excel Programming |