Auto delete
 

Hai everybody..
I wrote a macro for auto delete of blank rows. Itz working fine. The problem
is i cannot delete the rows which is having formulas. I mean i put =b26 in
b46 cell. i cannot delete the cell b46 if at all b26 is blank. In b46 cell it
is showing #REf. Can anyone help me to solve my problem