Combine from multiple sheets a range and then populate a ComboBox

[Dataminer1]

I would like to combine, from two sheets, a range and then populate a ComboBox.

Below is the code I use to load my list on my “Find” sheet from my “Page1” sheet.

Sheets("Find").ComboBox1.ListFillRange = "Page1!A1:A" & Sheets("Page1").Range("A" & Rows.Count).End(xlUp).Row

I also have a “Page2” and soon a “Page3” that follow the same layout.

My questions are… One, I do not know if this can be done and Two, If it can, will I hit a limit of what I can put in to the list? I hit the max number of lines excel 2003 can handle (hence the multiple pages).

Any suggestions?

 

[Dataminer1]

I am beginning to believe that my request is not possible. Anyone?