I have a sheet of client data. On a separate sheet I have a button that updates the client data (Add/amend/Delete). Once the data is altered, I also update the named ranges on the Client Data Sheet with VBA code.
I have 3 named ranges: Company List, Legal Name, and Client Data.
The problem I have is on a 3rd sheet, I have a combo box that uses one of the named ranges listed above. After changing the client data with VBA, the combo box list doesn't update.
For instance, I have 9 clients listed on the Client data sheet. I added one so now there are 10 clients listed. The named ranges are updated to include the 10th client, but on the combo box calling for the named range is not updated. If I delete the named range and rename it manually, the combo box list get updated.
How can I delete the named range in VBA without deleting the contents of that named range and rename the named range with VBA?
I have 3 named ranges: Company List, Legal Name, and Client Data.
The problem I have is on a 3rd sheet, I have a combo box that uses one of the named ranges listed above. After changing the client data with VBA, the combo box list doesn't update.
For instance, I have 9 clients listed on the Client data sheet. I added one so now there are 10 clients listed. The named ranges are updated to include the 10th client, but on the combo box calling for the named range is not updated. If I delete the named range and rename it manually, the combo box list get updated.
How can I delete the named range in VBA without deleting the contents of that named range and rename the named range with VBA?
