OK lets try this question .....

Rather than :

VB Code:

Me.Controls("cboRM" & i).RowSource = "'Data Source'!P3:P4"

.. I am using

VB Code:

Sheets("Branches").Activate
    Range("A2").Select
    Range(Selection, Selection.End(xlDown)).Select

.. to select my range, but how do I assign it as the Rowsource of my combobox ?

Any takers ?

Got it !

I used this :

VB Code:

cboDivision.RowSource = Range(Selection, Selection.End(xlDown)).Address

OK different combobox to original post, but you get the idea !

:)