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