View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] marston.gould@alaskaair.com is offline
external usenet poster
 
Posts: 102
Default Application.Match Type mismatch error

Tempquery is only one dimensional. And it contains about 12000 unique
items in the list.
The only thing I could think of is that in the line e is dimensioned as
a long while the items in query and tempquery are
variant/strings.....but that shouldn't matter I would think...