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

--
Message posted from http://www.ExcelForum.com

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


--
Regards,
Tom Ogilvy

"hotherps " wrote in message
...
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,41
through 0,96

Thanks


---
Message posted from http://www.ExcelForum.com/

Thanks Tom I'll try tha

--
Message posted from http://www.ExcelForum.com