VBA Code to add missing data in listbox

[dharvey1978]

Hi

I have a missing data problem. With the code below a user on here help me remember that when i change integer number brings the row number down but i'm now facing another issue at the bottom of the list box it is missing data. I thought as shown in the code below the "C:C" would read the entire column and if i add the Cell and row number in eg: C10:C12 all i get is a blank list box. I want to be able to add data into the rows and not keep having to change the code.

Please Login or Register  to view this content.

Thanks in advance
Donald

[romperstomper]

If you have blank cells in C1:C5 you will miss data. I'd suggest something like:

Please Login or Register  to view this content.

[WideBoyDixon]

Not sure about using CountA() - that would depend what is in the cells above C6. Try like this instead:

Please Login or Register  to view this content.

WBD

[dharvey1978]

Thanks both Rorya and WideBoyDixon they have work successfully.