On Saturday, 1 December 2012 10:52:03 UTC, Claus Busch wrote:
Hi,



Am Sat, 1 Dec 2012 02:41:48 -0800 (PST) schrieb robzrob:



Trying to make part of a macro work only if the target is in col B, otherwise exit. I'm doing this:



Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column < 2 Then Exit Sub

Your Code

End Sub





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

Aha! Vielen dank.