hi,
Can you not just add code to the combo that clears it then used the new range?
to clear use the .clear method?

or am i missing something?

Ross