I have an one-dimensional array that contains 11 elements. Now I only
need 3 elements and want to discard the rest from the array. So my
final array has only 3 elements. I need to code something like:
for i=1 to hbound(myarray)
if myarray ^in ('A, 'B', 'C') then delete
next

How to code it though? Thanks!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements