View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
mike mike is offline
external usenet poster
 
Posts: 216
Default 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"?