IF is true then resume not next line but one after?

[ianripping]

I have the statement:-

val1 = range("a1").value
i now want to say if val1 = "" then miss next line and carry on.

Cany anybody assist

 

[AlfD]

Hi!

You could turn it round:

if val1<>"" then {do the next line}

else {do the one after}

end if

 

[Harald Staff]

If val1 <> "" Then Msgbox "This is next line"

HTH. Best wishes Harald

 

[ianripping]

hmmn not fully with you on that on

 

[AlfD]

Ian:

You're right to be sceptical of my suggestion.

For some reason I turned your logic into an "either-or".

If the second line is always going to happen, irespective of whethe
Val1="", then Harald Staff's your man.

Al