HOW TO: Intersect two ranges?

  • Thread starter Kevin McCartney
  • Start date
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
 
Top