That's it. Thank you. It still doesn't do what I want it too, but I think
it is my morning fuzzy logic.

Thanks again.

"Nile_Hef" wrote:

This are two syntax errors he

Else: If cell = Null Then

You actually wanted this:

ElseIf cell = Null Then

The colon acts as a line break in VBA, and 'ElseIF' is all one word.

Regards -

Nigel