Thread: Array help.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jay Jay is offline
external usenet poster
 
Posts: 671
Default Array help.

Hi Guys,

Here's what I wanted to do using an array.

listed the ff column numbers (7, 11, 15, 19, 23, 27, 37, 35, 39, 43, 47,
51, 55, 59, 63) in an array and as I click in any part of the cell and press
ok it'll look in that series of value in the array and prompt "invalid
column" if its not found and returns "found" in the activecell if it has
found.

Thanks,
Jay