Select case in VBA

[sandu1]

Hello,

I am new to VBA and I getting confused.

How do I effectively use Select case in the below Code. I have Intersect code and I would like to use it in select case or if else..

Because, the first line of code has exit sub, so its coming out the code without even check the second intersect function. Please help.

Please Login or Register  to view this content.

[AlphaFrog]

Please Login or Register  to view this content.

[sandu1]

Thank you very much