This is just the sort of thing I was hoping for thank you. Only problem is it currently fails on the last line (highlighted below) saying Run-time error '1004' application-defined or object-defined error.
I can see what this line is attempting to do but still too green with VBA to be able to diagnose. If not immediately apparent to you either I will happy upload a sample file. Oh and yes - the toggle cell value will only ever be a dash "-" or a tick "ChrW(&H2713)" so hopefully this keeps things simple!
Bookmarks