Excel VBA - How do I refer to a cell's visible content rather than its formula? -

i'm trying loop through particular range in excel spreadsheet(("b13:b65"), specific) , hide rows have "x" in them. this:

for = 13 65 if cells(i, 2) = "x" or "x" rows(i).rowheight = 0 next

the problem i'm getting type mismatch error.

i assume happening because cells in range formulas rather text strings. example, contents of cell b13 are:

='monthly'!$c$13

i want code evaluate visible output of cell, not actual content.

i feeling there's easy solution here, i've been searching while no success. i'm rookie, obviously...

sub main()  each c in worksheets("sheet1").range("a1:d10")    'change range  if lcase(c.value) = "x"   '''rest of code  end if  next c  end sub

hj