View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Array instead of loop I'm sure

Hi Howard,

Am Tue, 31 Mar 2015 10:36:47 -0700 (PDT) schrieb L. Howard:

When I run the code the list on New List sheet is only the index numbers without the serial numbers to the left.


what exactly do you want to get into New List? You said the match cell
resize(,12). But most of the match cells are in empty rows. Therefore
there are no other values.
Please explain a little further.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional