View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Anders S[_2_] Anders S[_2_] is offline
external usenet poster
 
Posts: 57
Default Deleting data and element in a 1D array

Bob,

I have a 1-D VBA array with 600,000 elements.



2. Copy the array to a worksheet range, delete every third item in that
range (remembering to do it backwards), reload the array. You don't even
have to ReDim it.


Which Excel version, 2009 <g?

Anders Silven