If Else problem in an excel macro Solved/Closed

Question

Hello,

I have been trying to program a simple imbeded IF Else statement in Excel and it keeps throwing a Else without IF error.  What am I missing

    Sheets("Account Numbers").Select
    Range("A3:D3").Select
    Selection.Copy
    Sheets("Fax Sheet").Select
    If Range("B2") = 0 Then Range("A2").Select
    ActiveSheet.Paste
    Else: Range("A3").Select

rizvisa1 · Answer

If Range("B2") = 0 Then 
Range("A2").Select
ActiveSheet.Paste

Else
 Range("A3").Select
end if

marlabt · Answer

It is still throwing the "Else without If" statement.  What do I do now?  Help please


     If Range("B2") = 0 Then Range("A3").Select
    ActiveSheet.Paste
    Else
    Range("A2").Select
    ActiveSheet.Paste
    End If

rizvisa1 · Answer

Your problem is this

If Range("B2") = 0 Then Range("A3").Select

move 
Range("A3").Select
 to a next line

so it looks like

If Range("B2") = 0 Then 
Range("A3").Select

marlabt · Answer

Thanks much!!!!!!!!!!!!!!!

If Else problem in an excel macro

4 responses

Similar discussions

Subscribe To Our Newsletter!