View Single Post
 
Old 07-12-2020, 02:42 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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?
Code:
            Set oRng = oCCList.Range
            oRng.Select
Or you could always fall back on the macro being kicked off when you exit the CC
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote