Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete empty rows
hi,
i have a sheet in which there are like 180 or so lines. and some of the rows do not contain some data. and then there are some rows which contain data but that have a value in column B in which its length is greater than 3. how can i write code which deletes rows which contain no data and rows which contain a value with a length greater than 3 in column B? thanks in advance, geebee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
How to Delete empty rows in excel in b/w rows with values | Excel Worksheet Functions | |||
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
Delete Rows with Empty Cells with empty column 1 | Excel Programming | |||
delete empty rows between rows with text | Excel Discussion (Misc queries) |