I am getting compiler error with the below macro
Block if without End if
Help!!Please Login or Register to view this content.
I am getting compiler error with the below macro
Block if without End if
Help!!Please Login or Register to view this content.
@kishoremcp
Please check the code below. Place your "End if" statement on the desired condition.
Sub Pick_MacSSRR()
If Range("C2").Value = "Phone" Then
Call SSP
Call RRP
End If
ThisWorkbook.Worksheets("WCSAT").Activate
If Range("C2").Value = "Email" Then
Call SSE
Call RRE
End If
If Range("C2").Value = "Chat" Then
Call SSE
ThisWorkbook.Worksheets("WCSAT").Activate
End If
End Sub
you have to close each IF with End If like this
Please Login or Register to view this content.
If solved remember to mark Thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks