Hi, I have created a range in Excel which selects all of the blank cells in column 5 of another range. I now want to use an offset of (0,-4) in this range as the rowsource in a combo box. Unfortunatly I'm not having much success at the moment:
bob is certainly the range that I want but no luck in getting it to appear in the combo box. Any help would be appreciated even if to say it is not possible this wayDim bob As Range Dim a As Range Set a = Range("a1").CurrentRegion Set bob = a.Columns(5).SpecialCells(xlCellTypeBlanks).Offset(0, -4) bob.Select cboPatientName.RowSource = bob.Address