so by setting the break points ive traced It back to the line where is try to add my dynamic named range to combobox2
below is the code in the named range to add the jobs to the range, it seems to work in the names section?![]()
Private Sub UserForm_Initialize() ComboBox1.List = Range("janinvoices").Value ComboBox2.List = Range("jobs").Value End Sub
=OFFSET(jobs!$A$2,0,0,COUNTA(jobs!$A:$A),1)
Bookmarks