Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? -- Traa Dy Liooar Jock |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Worksheet_BeforeDoubleClick Stops Working | Excel Programming | |||
No help for "Worksheet_BeforeDoubleClick" | Excel Programming | |||
Worksheet_beforedoubleclick | Excel Programming | |||
Sub Worksheet_BeforeDoubleClick from elsewhere? | Excel Discussion (Misc queries) |