I get a VBA Excel 'Compiler Error: Object required'-Error. I am new to VBA coding, any help is aspir

[Bob G.]

Sub TF()
  Dim rng As Range
  Dim i As Long
  Dim TF As Long 'Value 'Range
  Set TF = Application.Match("TF", Sheets("Update").Range("1:1"), False) '.Value
 
  With ActiveSheet
  Set rng = .Range("A1:A" & .Cells(.Rows.Count, 1).End(xlUp).Row)
  For i = 2 To rng.Rows.Count
  rng.Cells(i, 4) = Application.WorksheetFunction.VLookup(.Cells(i, 1), Sheets("Update").Range("A:AZ"), TF, False)
  Next
  End With
End Sub

 

[Luke M]

The 'Set' method is used to define Objects. However, your TF variable is a Long (a number). So, change this line:
Set TF = Application.Match("TF", Sheets("Update").Range("1:1"), False) '.Value
to this"
TF = Application.Match("TF", Sheets("Update").Range("1:1"), False) '.Value