Worksheet_BeforeDoubleClick()

[Jock]

There are 5 seperate, non adjacent columns in which I'd like the user to be
able to select any cell and double click it resulting in a tick being placed
in that cell.
I can get it to work for a single column, but can't figure out how to apply
the code to include the other columns.
Piece of the code which I use:
......If Not Application.Intersect(Target, Columns("E:E")) Is Nothing Then.....
I also need columns N, P, S and AB included. Any thoughts?

 

[Jock]

Thanks Simon.
--
Traa Dy Liooar

Jock

Like this:

Code:
--------------------

If Not Intersect(Target, Range("E:E,N:N,P,S:S,AB:AB")) Is Nothing Then

--------------------




--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)