Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete cells.
Can any one give me a formula or a macro that will automatically delete
whatever i have in the cells below. I dont have anything specific text or numbers that can be identified in the cell to delete them (inorder to use Auto filter). I just need them blank. Here are the cells i want deleted: On Sheet called "Client Visit Input" B55:N85 B118:N148 B155:N185 B192:N222 B229:N259 B266;N296 B303:N333 B340:N370 B377:N407 B414:N444 B451:N481 B488:N518 On the sheet called "Monthly Income Input" B59 B74 B122 B137 B159 B174 B196 B211 B233 B248 B270 B285 B307 B322 B344 B359 B381 B396 B418 B433 B455 B470 B492 B507 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't delete or add to my cells in excel | Excel Discussion (Misc queries) | |||
How to delete all the blanc cells in a worksheet and shift cells l | Excel Discussion (Misc queries) | |||
Delete Cells not Available | Excel Discussion (Misc queries) | |||
How do I delete duplicate cells? | Excel Worksheet Functions | |||
Delete repeated Cells | Excel Worksheet Functions |