View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
R Avery R Avery is offline
external usenet poster
 
Posts: 220
Default Remove First Row from Variant Array FAST?

Suppose I have a 2D variant array, and I want to remove the first row
from it. Is there a really fast way to do that, rather manually copying
every value into a new variant array? Perhaps using API calls or
manipulating the underlying SAFEARRAY structure?

Also, a related question. Suppose I have a Double array with millions
of items in the array. Is there a quick way to chop it in half, perhaps
by altering the pointer to the first index and altering the number of
items in the SAFEARRAY?

I am not experienced with any of this stuff, but I thought it might be
possible. It would useful to me, if possible. Any help would be
appreciated.