Is there a function in VBA that can establish whether a particular value is part of an array, or is it necessary to actually cycle through all of the.
www.mrexcel.com