Most efficient way to clear bounded array

General
1

It is obvious to me that the best way to clear an bounded array but what about a bounded array?

What is the most efficient way to clear a bounded array. For example, would it be to one of the following?:

  1. Redim the array to -1 and then redim the array back to it’s desired bounds. I don’t know if it would be too expensive to do that.

  2. Redim the array to -1 but not redim back to the bounds.

  3. I realise this could depend on the size of the array. Loop through each value and assign it nil.

Thanks

2

Out of your list above, number 2 is the most efficient. However, the array would not be clear, it would be unbounded. If you want it bounded and clear then option 1 would be the way.

3

Thanks[quote=110350:@Mike Charlesworth]Out of your list above, number 2 is the most efficient. However, the array would not be clear, it would be unbounded. If you want it bounded and clear then option 1 would be the way.[/quote]