Macro Help

[Ola Sigurdh]

Hello

This line in a macro I found selects the whole column 6
If Target.Column = 6 Then
But if I want to just select F2:F42 instead of the whole column,what do I
change.
I tried to use
If Target.Range = ("F2:F42") Then
but it did not work.

Tia
Ola

 

[Bob Phillips]

If Not Intersect(Target,Range("F2:F42")) Is Nothing Then


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Ola Sigurdh]

Thank´s for your help Bob
I will try it soon

Ola