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