Thank you so much for your reply.
Did you also try creating a new worksheet and renaming it?
In my case, it only works fine if I select items from the combobox. I am getting this error on Excel 2010. I will try on other Excel versions and update the post.