View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Colleyville Alan Colleyville Alan is offline
external usenet poster
 
Posts: 11
Default Code works 1st time then Type Mismatch when checking for not blank cells

"mudraker " wrote in message
...
Why not do away with your loop and use

ilastrow = oxlWks.Worksheets("Sheet1").Range("A65536").End(xl Up).Row


this gets the last row with an entry in column a



Can not help you as to why your code fails


Thanks - that seems faster and more compact. The code crashing still bugs
me! But the goal is to get the thing working.

Thanks again.