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
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!!
Thanks for the quick response Richie, I shall follow your advise..
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 !!!!