Merge similar codes into one

Hi everyone,

I have the following seven codes used to fill a ListBox with data retrieved form a range (DACNRange).. they are almost the same .. the only difference between them is the range column number (highlighted with red) ..

Instead of these seven similar codes, Can we create a general code replaces them all?

Please Login or Register  to view this content.

I hope that my question is clear for all,

Thanks,

How do you call each procedure/ You need to create a Public Variable to replace the column number then set it with say the button click event