delete market with vba from quick pick list ?

[tom1904]

hi together,

knows anyone a code-snippet or a trigger i can use in vba to delete the actually selected market from my quickpick list
i'm walking through the list, analysing some data, which works fine...
markets where my criteria dont match i want to delete

thanks for your help
tom

[GaryRussell]

"-8" in cell Q2 will delete the current market from the quick pick list.

[tom1904]

hi gary,
thxs that's nice...

this "-8" wasn't listed in the user guide - special trigger cells

or i didn't just find it