What is a 'Block If without End If Compile Error' in an Excel VBA (Macro)

preview_player
Показать описание
Grab the Free VBA Quick Reference Guide
A Block If without End If error occurs when the VBA compiler is unable to find the End If that goes with an associated If Statement
Рекомендации по теме
Комментарии
Автор

the ads at the end of the video block the final screen...

goirish
Автор

I get this error if I try to end if it states my end if is without an if bock

Josivis
Автор

Hey! I think I´ve done my statement correctly and It doesn´t work!!
If Cargo = "Arquitecto" Then Tarifa_por_hora = 100
ElseIf Cargo = "Capataz" Then Tarifa_por_hora = 50
ElseIf Cargo = "Obrero" Then Tarifa_por_hora = 20
Else
Tarifa_por_hora = -1

End If


Please Help!!!

maferllaque
Автор

Heck! I have the full code with End If and I still get the stupid message

artiphoria