Else without If

[JacMeyers]

below is the macro i have but it is coming back with "Else without If" error
I'm trying to create a macro that when a cell = USHMTrig then it takes the user to a certain cell on a particular sheet within the worksheet.

Sub USHMTrigMac()
If L8.Value = USHMTrig Then
Do: Sheets("Example - US").Select
Range("B2").Select
Else
Exit Sub
End If
End Sub

What am I doing wrong?

 

[MUKESHY12390]

use this....

Sub USHMTrigMac()
Dim USHMTrig As Variant


USHMTrig = "search me"
If Workbooks("Name").Sheets("Name").Range("L8").Value = USHMTrig Then


Sheets("sheet2").Range("B2").Select




Else
Exit Sub
End If
End Sub

if you are using Do loop don't forget to close it.

 

[steve the fish]

Hi. I think you are trying to do this:

Sub USHMTrigMac()
    If Sheets("Sheet1").Range("L8").Value = "USHMTrig" Then
        Sheets("Example - US").Select
        Range("B2").Select
    Else
    End If
End Sub

 

[JacMeyers]

That helped to end the error message however when I run the macro, it doesn't do anything.
I created this standalone macro which worked...
Sub JumpTo()
'
' JumpTo Macro
'
'
Sheets("Example - US").Select
Range("B2").Select
End Sub

However, I want it to take me there based on the condition that
If Sheets("Sheet1").Range("L8").Value = "USHMTrig" Then

Any ideas?

 

[njimack]

Sub JumpTo()

If Sheets("Sheet1").Range("L8") = "USHMTrig" Then
Sheets("Example - US").Select
Range("B2").Select
End Sub