would greatly appreciate your help to resolve the following issue:
- Have a combobox that can pickup values from a list (not a table). All values available are names of specific ranges in the same sheet (named "Header")
- By changing the value on the combobox, i need the range named after the combobox value to be pasted to the cell A8 of the same sheet.
- Before each time a new range is pasted, the area A8:K40 should be cleared
I wrote the following code by using some examples from other threads in the forum, but get error message "run-time error '424':Object required"..
Any assistance would be more than welcomed!!