Hoping someone can help me with this.
I have been playing with a VBA routine that allows a person to select multiple rows in a sheet. (Not my work - I 'liberated' it from a you tube video).
The routine simply allows you to select a cell in column A and it will place a tick in the box and highlight the row with a colour using conditional formatting. Similarly clicking the same cell unticks the box and removes the highlighting colour.
This works fine if you only want to make one or two selections but becomes tedious if you want to select a lot of rows.
So, what I would like to do is be able to 'select all' by clicking Cell A1 and have it select all those rows that have an email address in the corresponding row in column R.
Similarly, clicking A1 again deselects everything.