delete row array

**ilkamalo** · 11-15-2010, 03:25 AM

i've problems with the following macro
i need to delete some entry in the array
if might help the array ha s about 3000 row and 600 column

Please Login or Register  to view this content.

all the best and thanks for help

**DonkeyOte** · 11-15-2010, 04:15 AM

You can "Empty" Items within an Array but physically deleting the Item is a little more cumbersome.

From what I can tell you're looking to populate a variant Array with the contents of a used range and then remove all Fridays, is that correct ?

What are you doing with the Array subsequently ?

My first point would be that you really don't need to iterate the Range row by row & column by column to populate, ie:

Please Login or Register  to view this content.

Nor do you really need to format each item within the Array per your date format.

If you can outline the overall plan we can probably help you streamline a little further.

**ilkamalo** · 11-15-2010, 08:15 AM

thank,for your help
this work is done so far without using array but working with rows and columns ,but it takes much time,so i thought using array it
would speed up my macro.
i need for each column the moving average last 32 friday,last 16 friday,last 8 friday,last 4 friday,last 2 friday,last 25 friday,last 12 friday,last 6 friday,
my thought was (as i do with excel) to delete all row except that related to fridays and to sum up as example last 32 value of the column and divide the by 32.

**royUK** · 11-15-2010, 08:17 AM

Attach a workbook, not images

**ilkamalo** · 11-15-2010, 09:35 AM

done,the macro is the "multy_array",you can run it,at the moment i've been able to substitute the entry that i'd like to delete(but i'not able) with the number 0