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

I

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
 
A

AlfD

Hi!

You could turn it round:

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

else {do the one after}

end if
 
A

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
 
Top