Hi
your current formula only checks if the cell 4 columns to
the right has a dot in it. It does NOT check we other 3
cells to the right
-----Original Message-----
I need a little help with the following code:
If .Cells(x, y).Value = "." _
And Cells(x, y).Offset(0, 4).Value = "." _
And counter < 8 _
And need 0 Then
.Cells(x, y).Value = "ENG"
= problem
I'm trying to check to see if the next four cells to the
right have the
value "." in them.
I can't seem to get it right, does Offset work
differently when you
want to check a range as opposed to a cell?
Thanks
---
Message posted from http://www.ExcelForum.com/
.