Please advise:
I need to name a range on Worksheet "Schedules" running from B3 to the last non empty cell in the B column.
I want the named rnage to be "NRWorkOrderNumber".
Question 1: How do i code this in VBA?
I have a Userform which will display the "NRWorkOrderNumber" named range in a Combobox (named "cbListWorkOrderNumbers"), which can select whichever value i need. I know to insert the value NRWorkOrderNumber in the RowSource field.
Also i have a CommandButton which is called "cbDeleteWorkOrderNumber", which when clicked will delete the entry from the named range. Obviously then i need to rename the "NRWorkOrderNumber" named range to not include the deleted value and to refresh the Combobox "cbListWorkOrderNumbers" to refelct the change.
Question 2: Is this a Dynamic Named Range?
Question 3: How do i code this in VBA?
Many thanks for any help.
I need to name a range on Worksheet "Schedules" running from B3 to the last non empty cell in the B column.
I want the named rnage to be "NRWorkOrderNumber".
Question 1: How do i code this in VBA?
I have a Userform which will display the "NRWorkOrderNumber" named range in a Combobox (named "cbListWorkOrderNumbers"), which can select whichever value i need. I know to insert the value NRWorkOrderNumber in the RowSource field.
Also i have a CommandButton which is called "cbDeleteWorkOrderNumber", which when clicked will delete the entry from the named range. Obviously then i need to rename the "NRWorkOrderNumber" named range to not include the deleted value and to refresh the Combobox "cbListWorkOrderNumbers" to refelct the change.
Question 2: Is this a Dynamic Named Range?
Question 3: How do i code this in VBA?
Many thanks for any help.