I use the VB in excel to do some statistics, but this code doesn"t work when it reaches 150 lines.
enter this person"s name in a cell followed by his ninth house cell (1x 9) and his name will automatically be displayed in this cell, but not after 150th line. no, no, no.

=IF(ISERROR(VLOOKUP("7","2--"!$AE$3:$AH$910,4,0)),"",VLOOKUP("7","2--"!$AE$3:$AH$910,4,0))

the error report goes like this:

is there any Daniel who understands VB? please ask