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.