View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keyur Keyur is offline
external usenet poster
 
Posts: 1
Default question on arrays in vba

hi

i am building an array (arr(n)) of values of n cells in a macro/

i want to check if a cell's (other than those n) value is in thi
array.

is it possible to do it in one step, like

if cells(1,1).value = arr(1 to n) then


Thanks for any hel

--
Message posted from http://www.ExcelForum.com