Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
question on arrays in vba
Yes, try this
If IsNumeric(Application.Match(Cells(1, 1).Value, Arr, 0)) Then 'is in the array End If -- Regards Juan Pablo González "Keyur " wrote in message ... 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 this array. is it possible to do it in one step, like if cells(1,1).value = arr(1 to n) then Thanks for any help --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3D Arrays | Excel Worksheet Functions | |||
Arrays Take too long. VERY HARD QUESTION. my head hurts : / | Excel Worksheet Functions | |||
formula question for arrays | Excel Programming | |||
Arrays | Excel Programming | |||
Arrays | Excel Programming |