Clearing Array contents

[BexleyManor]

mmmm, where to start!!

I have an array that I wish to 'flush out' the values from after a specific action has taken place in order for it to be re-populated with fresh values.

Any suggestions folks?? :dunno

[XL-Dennis]

Hi and welcome to VBAX :)

As a start check out Erase in the directhelp.

Kind regards,
Dennis

[BexleyManor]

Sorry, where do I find the directhelp section??

[Richie(UK)]

Hi BM,

How about using ReDim (without the Preserve option)?

Like this:


Sub Test()
Dim lArray() As Long
ReDim lArray(10) As Long
lArray(0) = 123
MsgBox lArray(0)
ReDim lArray(10) As Long
MsgBox lArray(0)
End Sub

HTH

[XL-Dennis]

Hi,

Write the word Erase in the VB-editor, highlight it and hit the F1-button.

Kind regards,
Dennis

[BexleyManor]

Dennis, thanks for that great little tip, I'll be using that again for sure!!

[BexleyManor]

Thanks for the quick response Richie, I shall follow your advise..

[Zack Barresse]

Hey there,

Did this information help you solve this one BexleyManor?

[BexleyManor]

Yes indeed, it was in conjunction with my do Loop question and both were solved to perfection, All hail the VBA Express Gods !!!! :vv