IF and ElseIf

Hello, I am having some trouble with my if and elseif statements. I have data in potentially 4 sheets and if a cell is blank it goes on to the next, if not it runs code and then goes on to the next sheet. I am having trouble with sheets getting skipped. Below is a breakdown of what i have.The Then after a blank cell should move on to the next sheet.

Sheets("Sheet 1").Select
If Range ("A2") = "" Then
Elseif Sheets("Sheet 1").Select Then
'RUNS CODE"

Sheets("Sheet 2").Select
If Range ("A2") = "" Then
Elseif Sheets("Sheet 2").Select Then
'RUNS CODE'

Sheets("Sheet 3").Select
If Range ("A2") = "" Then
Elseif Sheets("Sheet 3").Select Then
'RUNS CODE'

Sheets("Sheet 4").Select
If Range ("A2") = "" Then
Elseif Sheets("Sheet 4").Select Then
'RUNS CODE'

END IF
END IF
END IF
END IF

Please Login or Register  to view this content.

Is that what you mean? your question is not entirely clear

Regards

Dav

Sorry, what i mean is look at sheet 1, if blank go to sheet 2, if not run sheet 1 code and then go to sheet 2. if sheet 2 is blank go to sheet 3, if not run sheet 2 code and then go to sheet 3. etc etc.

I think the answer does that although

Please Login or Register  to view this content.

is maybe simpler, is that what you mean?

regards

Dav

AH I SEE. thanks that works