Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting the empty rows in Excel
Hi All,
I need your help to delete (at one single step) all empty rows in the spread sheet. Can you please help me? Thanks Regards Renga |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting the empty rows in Excel
you can use the autofilter to filter for blanks, then delete the
filtered rows, turn off autofilter. Regards, Shailesh Shah http://in.geocities.com/shahshaileshs/ (Excel Add-ins Page) If You Can't Excel with Talent, Triumph with Effort. "lbrrenga" wrote in message oups.com... Hi All, I need your help to delete (at one single step) all empty rows in the spread sheet. Can you please help me? Thanks Regards Renga |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting the empty rows in Excel
Hi lbrrenga
Emty rows or all rows with a empty cell in a column ? There are examples on this page http://www.rondebruin.nl/delete.htm Use the Loop examples and read the tips below the three macros You can use If Application.CountA(.Rows(Lrow)) = 0 Then .Rows(Lrow).Delete 'This will delete the row if the whole row is empty (all columns) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "lbrrenga" wrote in message oups.com... Hi All, I need your help to delete (at one single step) all empty rows in the spread sheet. Can you please help me? Thanks Regards Renga |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting the empty rows in Excel
Ron/lbrrenga
Your loop suggests a limited number of rows under variable EndRow = 100. If you swap it for EndRow = Range("a11").UsedRange.Rows.Count would this make it more dynamic? Regards -- BerbatovIsGod "lbrrenga" wrote: Hi All, I need your help to delete (at one single step) all empty rows in the spread sheet. Can you please help me? Thanks Regards Renga |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting the empty rows in Excel
hi PaxtonRoadEnd
There are three examples on my site Read the information 1) Loop through all the rows in the UsedRange (this is the first row with data till the last row with data on your sheet) It can be slower if the column that you check doesnt use so many rows or if your UsedRange is bigger then you data. you can find more information on Debra Dalgleish's Web Site about this http://www.contextures.on.ca/xlfaqApp.html#Unused 2) You can fill in the StartRow and the EndRow yourself. 3) You can fill in the StartRow and the code will find the last row with data in the column that you want to check. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "PaxtonRoadEnd" wrote in message ... Ron/lbrrenga Your loop suggests a limited number of rows under variable EndRow = 100. If you swap it for EndRow = Range("a11").UsedRange.Rows.Count would this make it more dynamic? Regards -- BerbatovIsGod "lbrrenga" wrote: Hi All, I need your help to delete (at one single step) all empty rows in the spread sheet. Can you please help me? Thanks Regards Renga |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - deleting trailing empty rows | New Users to Excel | |||
Deleting empty rows | New Users to Excel | |||
deleting empty rows | Excel Discussion (Misc queries) | |||
Deleting non empty rows | Excel Programming | |||
Deleting empty rows | Excel Programming |