Combo Rowsource

Hi just can't figure why:

Me.cboBase.RowSource = Worksheets(1).Range("a44:a45")

Will not work

My goal is to see this:

Me.cboComp.RowSource = Worksheets(1).Range("a44:" & strFinish)

Work any help would be greatly appreciated.

Sure would appreciate a response, judging by the quality of response and response time I've seen on this forum you guys could answer this simple question in a second. I just cannot get the entire range from the first sheet to fill the rowsource I've only succeeded in getting the first value through.

I know you guys can could you tell me how?

Hi guys had to bring this up again it should be a very simple solution just need to fill the combo box on a form with a range from a differenct sheet.

thanks