Empty column within an array

[CostCare]

Hi,

For a tool that i'm building, i have to do a lot of calculations in several worksheets trough VBA. since i was told that doing this in an array instead of the worksheet itself, i decided to use the array option to load in the worksheet data, do my calculations within the array and then put the array back into the worksheet.

My Code is as follow:

Please Login or Register  to view this content.

The ColumnLoop and GetResource are defined in the rest of the code, and this works. My Problem is the "MyLoopRange(UBound(MyLoopRange, 1), MyReadColumn).ClearContents" part. I want to empty this column of the array, but my code doesn't work .

Any thoughts?

Thanks in advance!

Bart

[Norie]

Bart

ClearContents is used with a Range object, you can't use it with an array.

To clear the column you might just have to loop, though if you can explain further what you are trying to do then some other method/approach might be possible.

[CostCare]

Hi Norie,

Thanks for the quick reply!

The GetResource = CheckResource tells me wether or not i have to empty all the rows for that column. Further into the whole code, i'm calling a function to fill these rows again. There is a scenario possible that the new situation has less rows filled then the old situation.

Looping can be an option, but im affraid of the extra time it can take..

What are your thoughts on this?

Regards,

Bart

[CostCare]

Looping did the job just fine!

Tnx!