Runtime error in spread

query
range

#1

Problem Link

SOLUTION LINK

CAN any one help me to find out why i m getting Runtime error
i my code it is easily readable and understandale please read and try to help me