That is an odd problem and the error message is not factually correct. It is unhappy because the selection is inside a dropdown CC but it works happily if the selection includes the full CC or is sitting outside of the CC. As you say, it makes no sense since the failing command isn't obviously using the selection anyway.

It appears you need to move the selection somewhere, what about selecting the CC range earlier?
Or you could always fall back on the macro being kicked off when you exit the CC

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia