Having trouble changing a combobox fill list with a macros

Here is my problem,

I have a search macros that populates the range, searchresults. I have a button that clears the search that change and sets it to the range, vendor. I just want to set the combobox list fill range between these two when I search and clear search but I am getting a runtime error when I run the code and I don't know how to fix it.

Here is the line of code i am having problem with.

Please Login or Register  to view this content.

I would rather not use the activesheet thing either. It just seems clunky.

David

I don't really get what you are trying to do, but maybe:

Please Login or Register  to view this content.

that is what I want, but it now says runtime error '70'
That is exactly what I want.

I fixed it by using .address instead of .value