Selection needs to be between columns C and N

[mucah!t]

Hello all,

The user should be able to select all cells on the sheet.
However in order to run a certain macro properly the user should select a range from column C till N.
I'd like to macro to check if the range is from C till N, not more and not less, before it continues.

Any ideas?

 

[shg]

Maybe ...

    If Intersect(Selection, Columns("C:N")).Cells.Count <> Selection.Cells.Count Then
        MsgBox "Bad boy!"
        Exit Sub
    End If

 

[mucah!t]

Thanks Shg!

 

[mucah!t]

One thing though shg, it works when a range greater than C:N is selected, but does not when a range smaller than C:N is selected [i.e. C:K]

 

[mucah!t]

Perhaps someone else?