View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Code for multiple select of cells

Hi Howard,

Am Mon, 27 Oct 2014 03:05:19 -0700 (PDT) schrieb L. Howard:

Claus's Sub MultiSelect() code all cells selected in a blink.

Claus's Sub MultiSelect2() code all cells selected in blink & 1/2.


I wondered about your answer because I thought the Find method is faster
than a For each loop.
But you are correct. Good to know for the future ;-)


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