VBA Lesson 11 - Populate an array with no duplicates - ExcelVbaSql.com 20+ hours of FREE training!

[6642633]

Headache from your shifting the screen left & right!

[techie53d]

Thanks man.

[krisnatarajan]

Thanks buddy

[Phlynt]

Hi,

First, Really Appreciate this video.

Question: How do you handle a value of 0 (zero). I believe the problem is because you have the myarray() size to be 1 larger and the last value is 0 so it thinks that it's already in the array.

Thanks for any help.

[caruv28]

=) +10

[nanao56]

This is pretty usefull tutorial! Is there a place where you can make the spreadsheet with the code be available?