excel - If #REF! then hide certain rows -

i have created 2 sheets, sheet no. 1 shows data nicely , other imports data. therefore sheet no. 1 gets data sheet no. 2. there no data in sheet no 2. gives cells in sheet 1 "#ref!". when happens need hide rows in sheet 1.

so imagine this

sub hidecharts()  beginrow = 132 endrow = 138 chkcol = 8  rowcnt = beginrow endrow     if cells(rowcnt, chkcol).value = 0         cells(rowcnt, chkcol).entirerow.hidden = true     end if next rowcnt          rowcnt = beginrow endrow             if cells(rowcnt, chkcol).value <> 0                 cells(rowcnt, chkcol).entirerow.hidden = false             end if         next rowcnt end sub  

however works if data 0 , got no clue on how catch #ref! hides rows contains 0 value, need catch rows 130 140

so thought, else turn stack overflow?

like this:

change if cells(rowcnt, chkcol).value = 0 then if cells(rowcnt, chkcol).value = 0 or iserror(cells(rowcnt, chkcol).value)

sub hidecharts()  beginrow = 132 endrow = 138 chkcol = 8  rowcnt = beginrow endrow     if cells(rowcnt, chkcol).value = 0 or iserror(cells(rowcnt, chkcol).value)         cells(rowcnt, chkcol).entirerow.hidden = true     else           'you don't need if rows visible @ start           cells(rowcnt, chkcol).entirerow.hidden = false     end if end sub