So, it seems that it is for sure something with the listbox if calculate, then unselect all when linked to DynamicNamed range, not static named range, or static range. This is baffling. I'm new to VBA so maybe there's something I'm missing but this is a royal pain. Solutions?
Bookmarks