Thread: Code for multiple select of cells
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
  
Posts: 852
Default Code for multiple select of cells


Hi Garry and Claus,

I am using the range A1:H50 testing. All cells filled with 5.

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

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

Garry's code Sub FindMyVal() errors out with the full range. Reduce cells around to about 30 - 40 works okay.

Glad to have all the options. Thanks.

Howard
Reply With QuoteReply With Quote