Im trying to populate an array with three fields per row from the outlook address book. The code im using is as follows (ive omitted
the outlook classes, references etc as my problem is to do with the vba array itself and i dont think the source of the data is relevant in this case) .
The problem is at the "Redim preserve" statement. Im basically trying to have the three items on one row eventually on a worksheet, and the next result on the row below it and so on
online searches say you can only redim the last dimension of the array and ive tried different things but cant quite get the result..very frustrating.
When i step through the code, it populates the first three elements and thats it..i guess because the size of the array is not changing, so its the resize thats letting me down .
Will be grateful for some help.
thanks
Please Login or Register to view this content.
Bookmarks