K
Kevin McCartney
Hi TWIMC,
I've the following code at the start of the 'Worksheet_SelectionChange'
private sub procedure but for some unknown reason to me it doesn't think my
selected range is within rows 1 to 10.
Basically, when I select a cell range, if some part of that selected range
crosses over row 10 then I don't want the procedure to run.
So if my Target range is $B$7 or $B$5:$B$10 I want it to Exit Sub
If Intersect(Target, Application.ActiveSheet.Rows("1:10")) Then Exit Sub
Can someone enlighten me as to where I am going wrong
TIA
KM
I've the following code at the start of the 'Worksheet_SelectionChange'
private sub procedure but for some unknown reason to me it doesn't think my
selected range is within rows 1 to 10.
Basically, when I select a cell range, if some part of that selected range
crosses over row 10 then I don't want the procedure to run.
So if my Target range is $B$7 or $B$5:$B$10 I want it to Exit Sub
If Intersect(Target, Application.ActiveSheet.Rows("1:10")) Then Exit Sub
Can someone enlighten me as to where I am going wrong
TIA
KM