Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete columns if cells have no data
..Hi
I have a worksheet where rows 1 & 2 and columns A & B are fixed headings. I would like a macro where any columns (C:BH) are deleted if they have no data. All of the cells in the range (C3:BH500) have formulas. I have tried to adapt other similar solutions found here, but to no avail. Any help would be greatly appreciated. Malcolm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Columns and Color Cells | Excel Discussion (Misc queries) | |||
How to Delete Extra Cells and Columns | Excel Discussion (Misc queries) | |||
Delete rows with empty cells in columns B&C | Excel Discussion (Misc queries) | |||
Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
delete columns and rows-cells equalling zero or any selected value | Excel Worksheet Functions |