Clearing an Array

Guest · Nov 23, 2004

Is there a command that empties an array of it's existing contents?

Guest · Nov 23, 2004

You can use redim without using preserve.

JE McGimpsey · Nov 23, 2004

Take a look at the "Erase statement" topic in XL/VBA Help.

Guest · Nov 23, 2004

Thanks for the help.

Jim Thomlinson said:
You can use redim without using preserve.

Tom Ogilvy · Nov 23, 2004

Look at the erase command.

Baffled with assignment of range to array why won't it work??? Anyhelp appreciated	4	Jan 29, 2014
Clearing Array Contents	1	May 5, 2007
vba array logic	3	Dec 5, 2014
Array to Multiple Arrays	3	Jun 14, 2013
Is the array empty?	4	Mar 14, 2008
How to read Excel Array to vb.net Arrays?	20	Oct 12, 2013
Maintaining variables after program ends	3	Mar 11, 2010
clearing an array	7	Sep 4, 2009

Ask a Question