Given the regularity of your ranges (they all differ by 6), you can use this
mathematical relationship to test if the Target row is within your range...

If Abs(Target.Row - 106) <= 39 And ((Target.Row - 67) Mod 6 = 0) Then

--
Rick (MVP - Excel)


"Leiprecht" wrote in message
...
How do you use If Target.Address = _____ Then for more than one cells.

The cells I want are
F67 Or F73 Or F79 Or F85 Or F91 Or F97 Or F103 Or F109 Or F115 Or F121 Or
F127 Or F133 Or F139 Or F145

Thanks for your help in advance.