Thread: Auto delete
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gane gane is offline
external usenet poster
 
Posts: 10
Default 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