On Thu, 24 Jan 2008 01:34:01 -0800, Gemz
wrote:

The code did not work, the following line was highlighted in red:

ElseIf Len(c.Offset(0, -2).Text & c.Offset(0, -1).Text & c.Text) = 0
Then

i tried to move it back or forward a little incase it was messing with the
syntax but it didnt work.


Darn word wrap: The "Then" should be on the same line as the Elseif STatement

So position your cursor at the "0" at the end of the elseif line, and <del
until the "Then" comes up to the same line.
--ron