Why does zoom level affect/hinder procedures in Excel VBA? -

so while working on data collection macro noticed gave run-time error when zoomed far out (cells had # symbol), when zoomed in enough see numbers involved in code works fine. reasoning behind this? have thought numbers displayed in excel window printed other source, rather being source of data themselves.

for each cell in .range("b2:gl2") if cell.text = trussarray(0)     col1 = cell.column     goto nextloop end if next  nextloop: each cell in .range(.cells(3, col1), .cells(3, col1 + 7))     if cell.text = trussarray(1)         col2 = cell.column         goto done     end if next