View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nile_Hef[_2_] Nile_Hef[_2_] is offline
external usenet poster
 
Posts: 23
Default Help with IF Else:IF statement

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