Target Column with range

Hi Guys,

I've been asked to look at a document for a colleague.

They have the following code:

If Target.Column <> 6 Then
Exit Sub 'Wrong column clicked on
End If
This stops the Macro if it wasn't run from column F.

They want to add it to column G (7) How do I add it so that it says to the effect of

If Target.Column <> 6 or 7 Then
Exit Sub 'Wrong column clicked on
End If

VBA is a bit "stupid" you need to tell him each time which column

Please Login or Register  to view this content.

Hi,

They come back and told me that there needs to be a blank column in between so it would be 6 or 8.

Unfortunatley Norie your solution wouldn't work in that case.

Roel, I've tried yours, as seen below, but afterwards it is not working for either the original column or the new column

Please Login or Register  to view this content.

Could we do it as

Please Login or Register  to view this content.

obviously this would need to be something like if Target.Column =6 the do nothing else if Target column = 8 then do nothing else exit sub????

Norie, I love you!!!!

Been racking my head for hours!

Works perfectly.