A little Help With VBA Columns Please

[Mike54]

I have a short Sub that runs well but i'd like to put a msgbox in so that if the user selects the wrong column they get a warning. I can't seem to get anywhere near it.

The length of the list varies day to day (hence it's by user selection) but the column (12 or L) is always the same.

How do i put a msgbox in so that if any other column is selected the user recieves a warming "Wrong Column selected"

Thanks

Mike

 

[VoG]

Try

If ActiveCell.Column <> 12 Then
    MsgBox "Wrong column", vbExclamation
    Exit Sub
End If

 

[Mike54]

Brilliant thank you, I've been dancing around that for ages and getting nowhere.
Cheers
Mike