Runtime Error '91' Object variable or With block variable not set

[treyabrown]

Can someone help me fix my code. I am trying to loop through a column that has numbers beside each of the new files. For each i it should set the range as an offset 2 columns over and pull that file name, but when it loops through I get a runtime error '91'

Then at the bottom I am trying to loop through each of the new file names and move it over to the column "already uploaded" so they don't show as new the next time it is run.

Sub UploadNewData()
Dim FileName As Range
Dim FullFileName As String
ActiveWorkbook.Sheets("Comparison").Select
For i = 1 To Range("NewFiles")
FileName = Range("F:F").Find(What:=i, LookIn:=xlValues).Offset(0, -2)
FullFileName = Range("FilePath") & FileName
ChDir (Range("FilePath"))
Workbooks.Open FileName:=FullFileName
Cells.Select
Selection.Copy
Sheets("Raw Data").Select
Cells.Select
ActiveSheet.Paste
Next i
ActiveWorkbook.Sheets("Comparison").Select
For i = 1 To Range("NewFiles")
Set FileName = Range("F:F").Find(What:=i, LookIn:=xlValues).Offset(0, -2)
FileName.Copy
Range("B" & Rows.Count).End(xlUp).Offset(1).PasteSpecial xlPasteValues
Next i
ActiveWorkbook.Save
End Sub

 

[Norie]

You need to use Set throughout for FileName.

For i = 1 To Range("NewFiles")
    Set FileName = Range("F:F").Find(What:=i, LookIn:=xlValues).Offset(0, -2)

 

[MARK858]

For i = 1 To Range("NewFiles")

Range("NewFiles") the way you are using it should also be a number not a range.
What exactly is Range("NewFiles")?
Including what is the start cell of Range("NewFiles")?

 

[treyabrown]

You need to use Set throughout for FileName.

For i = 1 To Range("NewFiles")
    Set FileName = Range("F:F").Find(What:=i, LookIn:=xlValues).Offset(0, -2)

I tried using "Set FileName ="
but after the first loop I get Error '91'

 

[Norie]

That probably means what you are trying to find isn't being found where you are looking for it.

When that happens Find returns Nothing and you can't offset from nothing.

What exactly, in words, are you trying to do with the code?