ExcelBanter - ReDim=overwrite?

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

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

- - ReDim=overwrite? (https://www.excelbanter.com/excel-programming/371140-redim%3Doverwrite.html)

Arne Hegefors

ReDim=overwrite?

Is it true that when you ReDim an array all info that previously populated
the array is lost after the ReDim statement?

Bob Phillips

ReDim=overwrite?

Yes, it is true. Don't you believe me?

You can preserve it though as I showed you. Checkout Redim in help.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Arne Hegefors" wrote in message
...
Is it true that when you ReDim an array all info that previously populated
the array is lost after the ReDim statement?

All times are GMT +1. The time now is 10:23 PM.