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
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