Hi guys. I'm trying to set the rowsource of my combobox to data on a worksheet. The range of cells I want to refer to is dynamic, but I don't want to refer to a range. Here's what I have and I'm not sure why it's not working:
Dim toEnd As Double

toEnd = 5

Do Until Sheets("Trial Balance").Cells(toEnd, 2) = Empty
toEnd = toEnd + 1
Loop

frmTransEntry.cbx1.RowSource = "'Trial Balance'!b5:b" & toEnd - 1

Any help?