Dear all
How can I abort a code when the user has selected multiple cells, that are not directly in sequnce... e.g. code should run if the user has selected "A1:A10", but not when the user as selected "A1:A10,A15:A25".
Thanks
FD
Dear all
How can I abort a code when the user has selected multiple cells, that are not directly in sequnce... e.g. code should run if the user has selected "A1:A10", but not when the user as selected "A1:A10,A15:A25".
Thanks
FD
Last edited by FallingDown; 01-22-2021 at 01:12 PM.
Something like:
![]()
If selection.Areas.count > 1 then msgbox "Please do not select more than one block of cells" Exit sub end if
Everyone who confuses correlation and causation ends up dead.
Thank you, Rory
Sorry for the late feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks