| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO TO HIDE BLANK ROWS
I have developed a model that has 190 lines but certain cells are blank ie
(-) and i would like to hide that row were a certain cell is blank. How do I write code for the macro to start at say C1 and then move down to C2 etc and then when it finds a cell that is blank ( but contains a lookup formula) it will hide that row and then continue until say come to c192 which contains the word END. Can anybody help me please. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to HIDE blank rows | Excel Worksheet Functions | |||
| Macro to Hide blank rows | Excel Programming | |||
| Macro hide rows with blank data in cells | Excel Programming | |||
| Macro to hide blank rows | Excel Programming | |||
| macro to hide rows if cell is blank | Excel Worksheet Functions | |||
Threaded Mode
