Macro Help

O

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
 
B

Bob Phillips

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


--

HTH

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