A more difficult one this time.
Is there a way of setting the input range on a combo box to a vale set in a cell?
ie, if my current input range is A2:A40 and i then users add another 20 records to that column, i need the combo box input range to change to A2:A60, so I can leave the sheet unmonitored for the users to add lines and not have to manually change the input range of the combo box.
Many thanks,
Lee.
Is there a way of setting the input range on a combo box to a vale set in a cell?
ie, if my current input range is A2:A40 and i then users add another 20 records to that column, i need the combo box input range to change to A2:A60, so I can leave the sheet unmonitored for the users to add lines and not have to manually change the input range of the combo box.
Many thanks,
Lee.