Worksheet_BeforeDoubleClick = Multiple Ranges

Hi,

I'm using the Worksheet_BeforeDoubleClick method and have set the range "PIDTBL1" as the area where the user can double click. However, I would also like to add two other ranges as areas where a user can double click, however I'm not sure how to do it.
As well as PIDTBL1 I'd like to use the ranges PIDTBL2 and PIDTBL3 as well. I'm not sure if I can use an "or" function or if I need to need to use 'ELSEIF'... or something else??

This is the code I have:

Please Login or Register  to view this content.

Any ideas? Thanks

Hi, that works great, thanks!