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??
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??
Last edited by BexleyManor; 07-28-2004 at 04:22 AM. Reason: Better explination of problem, hopefully!!
Hi and welcome to VBAX
As a start check out Erase in the directhelp.
Kind regards,
Dennis
Sorry, where do I find the directhelp section??
Hi BM,
How about using ReDim (without the Preserve option)?
Like this:
HTHSub 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
Thanks for the quick response Richie, I shall follow your advise..
Hi,
Write the word Erase in the VB-editor, highlight it and hit the F1-button.
Kind regards,
Dennis
Dennis, thanks for that great little tip, I'll be using that again for sure!!
Hey there,
Did this information help you solve this one BexleyManor?
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Yes indeed, it was in conjunction with my do Loop question and both were solved to perfection, All hail the VBA Express Gods !!!!