Transpose Array Result Empty

[aprildu]

I have an array that is set to variant and then redim preserved. I can see it's clearly populated in the locals window however it's not showing on sheet when I transpose it:

Please Login or Register  to view this content.

Similar code works for another two routines but this one is stubborn. I don't know why it comes up empty.

[jindon]

If you get error on the first VLookup, Err.Num stays the same all the way, unless you clear.

Please Login or Register  to view this content.

[aprildu]

Thank you. I actually just figured out why. It's because some comments exceed 255 characters that the array just stops functioning as normally it does.

[jindon]

Then you should avoid Transpose function

Please Login or Register  to view this content.

[aprildu]

Then how can I get the comments by using array? I don't want to do one by one as it's much slower

[jindon]

See my previous post.

You should get familiar with 2D array.

[aprildu]

Thanks I am on mobile that I missed the rest. Will try tomorrow to see if it works. I do know multi dimensional array but didn't know it can solve the character limit issue

[aprildu]

Thanks it worked! First I made an error of "redim preserve" the array which should have been just redim