I have the following function in my worksheet that works
nicely. It check to see if one cell to the left starts
with 8 blank spaces (others start with more). If only the
first eight characters are spaces, do something,
otherwise, do something else.

=IF(AND(LEFT(a12),8)=REPT(" ",8),MID(a12,9,1)<" "),Dome
Something, Do something else).

I would love to be able to write an IF statement in VBA
that does this. It looks as if it's going to be a nested
if statement, but can these functions be used?

A12 will vary of course, so I am going to have something
like "RC[-1]".

Thanks for any insight.

Don