View Single Post
  #19   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 again,

Am Tue, 31 Mar 2015 19:44:46 +0200 schrieb Claus Busch:

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.


or should I move the match cells before copy the range?
But if I unmerge the cells most of the match cells are in column C and
when I move they are in column B.


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