Limiting a SheetBeforeDoubleClick to cell range

[apeoortje]

I'm using the following code to enter the time on a goup of cell, is there any way on limiting it'll only work in cells C434?

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Selection.Value = Time
End Sub

 

[Loomah]

Hi
have a look at the Intersect method in help.

You should end up with something like

if not intersect(target,range("a1:c5")) is nothing then
'do stuff
end if

Happy Friday

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[apeoortje]

thank you very much, you a life saver