Well, when I run the visual basic recorder, I copy a set of vertical cells. From there I go to find-Goto-and select a referenced cell that I've "named" and then special paste to that named cell. Now I have have to be able to have the user select the named reference, but when I run the macro, instead of stopping, it selects the same from the list and didn't even stop.
I've had an old macro before this and doesn't run on 2016.
Something like that which allowed the user to select.