ExcelBanter - Clearing Array Contents

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Clearing Array Contents (https://www.excelbanter.com/excel-programming/388808-clearing-array-contents.html)

Ken Hudson

Clearing Array Contents

I am using an array in a VB loop.
How do clear the contents of an array in VB?
TIA.

--
Ken Hudson

merjet

Clearing Array Contents

If you declared it w/o dimensions, then use ReDim.
If you declared it with fixed dimensions, then use Erase.

Hth,
Merjet

All times are GMT +1. The time now is 10:48 AM.