Conditon If / ElseIf

[stan1020]

Hello,

I am trying to use a condition to jump to a lign in my program
The condition is based on the fact that one cell is empty or not,

I have tried the following code, but it is not working,
does anybody have a magic idea?

Thanks!

[first_file].Offset(1, 0).Select
If [first_file].Offset(1, 0) Is Empty Then
GoTo onefile
ElseIf [first_file].Offset(1, 0) Is Not Empty Then
GoTo severalfiles
End If

 

[Macropheliac]

Try it this way:

[first_file].Offset(1, 0).Select
If [first_file].Offset(1, 0).Value = "" Then
GoTo onefile
ElseIf [first_file].Offset(1, 0) <> "" Then
GoTo severalfiles
End If

 

[stan1020]

Thanks

I did not think about this..

Thanks so much!