conditionally delete some elements from an array
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 |
conditionally delete some elements from an array
Clui wrote:
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 Easiest is to create a new array with the content that you require. Or, if it is a dynamic array then you could move the items you want to the first 3 elements and ReDim Preserve MyArray(1 To 3) Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
All times are GMT +1. The time now is 10:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com