General questiion about my code on two different sheet

[ipbr21054]

I have a code which works on a worksheet fine.

I then copied it to another worksheet in a different workbook BUT i kept seeing an error saying Not Defind.
The line when debugged is shown below in Blue.
So i added the Line of code in Red & works fine.

My question is Why when on the other sheet does it run WITHOUT the code in Red & Blue ?

Should i be using the code below also on the other sheet ?

Thanks

Private Sub FindDog_Click()
    Dim myRange As Range
    Dim myCell As Range
    Set myRange = Range("Table2").ListObject.DataBodyRange ' CHANGE TABLE NAME
    For Each myCell In Intersect(Columns("C"), myRange) ' CHANGE COLUMN LETTER FOR WHERE TO LOOK FOR VALUE
    If myCell.Value = "BUDDY" Then ' CHANGE NAME OF WHAT TO LOOK FOR
      With Range("A" & myCell.Row) ' SELECT CUSTOMER IN COLUMN A ONCE FOUND
        If MsgBox("BUDDY LOCATED AT ROW: " & myCell.Address(0, 0) & vbCr & vbCr & _
          "THE CUSTOMER IS : " & .Value & vbCr & vbCr & _
          "IS THIS WHAT YOU ARE LOOKING FOR ?", vbCritical + vbYesNo, "FIND BUDDY") = vbYes Then ' CHANGE TEXT TO SUIT
          .Select
          Exit Sub
        End If
      End With
    End If
  Next myCell
  MsgBox "THERE ARE NO TO BE FOUND" & vbNewLine & vbNewLine & "SO THE SEARCH IS NOW COMPLETE", vbInformation, "FIND BUDDY MESSAGEE" ' CHANGE TEXT TO SUIT
  Range("A2").Select

End Sub

 

[rlv01]

Probably because the first sheet does not have an Option Explicit statement (which forces you to declare all variables) at the at the top of the code module, while the second sheet does have an Option Explicit statement.

With VBA, you can be lazy and not declare variables. From a programming practice standpoint is it VASTLY better to always declare all variables. The Option Explicit statement enforces variable declaration, and you change change the VBE options to turn it on by default.

 

[ipbr21054]

You are correct many thanks.