Offset Between?

[hotherps]

Is there a way to put a "between condition into and offset statement?

If .Cells(x, y).Offset(0, -1) = "" Then
If .Cells(x, y).Value = "." _
And .Cells(x, y).Offset(0, 41) = "." _
And need > 0 Then
.Cells(x, y).Offset(0, 0).Resize(1, 42).Value = "MMS"

What If I want to apply the same code to the range of Offset 0,4
through 0,96

Thank

 

[Tom Ogilvy]

for k = 0 to 1
y = y + k*42
existing code
Next

 

[hotherps]

Thanks Tom I'll try tha