clearing all values of a 2 dimensional array

bjr157 · Apr 4th, 2002, 09:16 AM

in VBA how do you reset all the values of a 2 dimensional array back to 0s, i know i could use 2 nested for statements but that takes to long and its a big array that needs to be cleared a lot. is there anyway to do it in one line of code? ive been trying stuff like

clear(MyArray())

i dont have any manuals so any help is appreciated, thanks.

Tom Schreiner · Apr 4th, 2002, 09:35 AM

Erase statement

Dim ArrayName(1 to 2, 1 to 2)

to clear it

Erase ArrayName

Look up erase in help.
Different types are treated differently with this statement.
Tom

Al Chara · Apr 4th, 2002, 09:38 AM

How about ReDim.

ReDim MyArray(1 To 5, 1 To 10)

Change (1 To 5, 1 To 10) to your dimensions.

Apr 4th, 2002, 09:38 AM	#3
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	How about ReDim. ReDim MyArray(1 To 5, 1 To 10) Change (1 To 5, 1 To 10) to your dimensions. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 09:16 AM	#1
bjr157 Board Regular Join Date: Mar 2002 Location: Philadelphia Posts: 100	in VBA how do you reset all the values of a 2 dimensional array back to 0s, i know i could use 2 nested for statements but that takes to long and its a big array that needs to be cleared a lot. is there anyway to do it in one line of code? ive been trying stuff like clear(MyArray()) i dont have any manuals so any help is appreciated, thanks.

Apr 4th, 2002, 09:35 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Erase statement Dim ArrayName(1 to 2, 1 to 2) to clear it Erase ArrayName Look up erase in help. Different types are treated differently with this statement. Tom