Do something when all cells are selected

[ola7mat]

Hello,

I have a macro that looks like this,

Please Login or Register  to view this content.

This helps prevent users from selecting more than one cell at a time.
However I am looking to handle a scenario when the user tries to select all the cells on the sheet.

Does any body know how i could write that, i.e. if user selects all the cells on the page then do X?

Thanks
Matt

[6StringJazzer]

Try this:

Please Login or Register  to view this content.

[xladept]

Try this:

Please Login or Register  to view this content.

[shg]

xla, that won't work.

I like 6SJ's suggestion. Another way:

Please Login or Register  to view this content.

[xladept]

@ shg - I tried it before posting But your way is better

[ola7mat]

thanks for your feedback guys, both options worked for my version of excel.

[shg]

Curious. I get an overflow error with all cells selected, because Count is Variant/Long.

[xladept]

@ shg - That's why I used the On Error.

@ ola7mat - You're welcome and thanks for the rep!

Much neater with shg's code line:

Please Login or Register  to view this content.

[shg]

@ shg - That's why I used the On Error.

Completely missed that, sorry.