Case with Intersect only works if first case true

[BobZZ]

The following code works if the selected cell in within the first named range (columns B:J) but if I try putting the activecell in the next named range (columns K:S) an error occurs "object variable or with block variable not set". What I am trying to do is determine which named range the selected cell is in. If it isn't in any of the 5 named ranges then execute the code section that the activecell isn't in any of the 5 specified named ranges. Why does it work in the first case if the activecell in in that range but fails if I try putting the active cell within the next named range. I am doing entire columns for named ranges so Line1Cols are B:J, Line2Cols is defined as K:S and so on.

Please Login or Register  to view this content.

[TheSilkCode]

Hi BobZZ,

I couldn't get your code to work because intersect returns an error if there is no overlapping cells, so doesn't work well in Select... Case. I was able to get it working with this following code however, hope it is still useful to you in this format-

Please Login or Register  to view this content.

Regards,
TheSilkCode