Type mismatch problem?
Empty cells value is inferior to any numerical positive
value.
If you don't have any numerical value greater than 100000
till you reach empty cells your loop won't finish ever.
Which was exactly the change of "cells" with "range"?
|