Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete rows that are empty across columns
I have the following columns that are a result of a pivot table. I would like
to delete the folllowing occurences. I tried using the range function but got a runtime error 1004. Something like: ' If Not Range("Col1").Value Is Nothing Then ' Rows.Delete Col1 Col2 a a b X X X X (delete) X X X X X (delete) I want to delete rows where Col1 = X and Col2 = X does not exist. To complicate things, this is a pivot table where Col1 and Col2 are further broken down into a and b. I thought that by using Range that a and b would not need to be accounted for individually. Thanks for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I delete multiple empty columns in Excel at one time? | Excel Discussion (Misc queries) | |||
Delete empty rows from print in Excel | Excel Worksheet Functions | |||
Delete rows in filter view | Excel Worksheet Functions | |||
Delete rows with empty cells in columns B&C | Excel Discussion (Misc queries) | |||
how do i delete the extra empty rows and columns that i dont need. | Excel Discussion (Misc queries) |