Need help with an Application.Match line that uses variables to define everything

[RainbowGurl44]

Hi, all!

I'm a total newbie at VBA, and I'm trying to get this code to use some pre-defined variables to accurately define a range of cells within a column. This range is going to keep changing... there's a loop.

If the code looks messy, that's probably due to my efforts to split everything up in the hopes of isolating the problem.

For Each ATA In MyRange

Set NextATA = ATA.Offset(1, 0)
'Has it go through each ATA in the list, one at a time, creating a workbook for each one.

'STILL NEED TO FIX THIS PART BELOW.


Set RepairListRange = Workbooks("Estimate Sheet Template.xlsx").Worksheets("STICK CONVERTED PDF HERE").Range("D1:D3000")
Set RepairListFirst = Application.Match(ATA.Value), Range("RepairListRange"), False)
RepairListFirst = RepairListFirst + 1
Set RepairListLast = Application.Match(NextATA.Value, Range("RepairListRange"), False)
RepairListLast = RepairListLast - 1
Set RepairList = "D" + RepairlistFirstRow + ":D" + RepairListLast

The preceding variable declarations are:

Public ATA As Range, MyRange As Range
Public NextATA As Range
Public RepairList As Range
Public RepairListFirst As Variant
Public RepairListLast As Variant
Public RepairListRange As Range
Public Repair As Range

The error code I've been getting is: Run-time error '13': Type mismatch. I've been trying putting things in quotes, and out of quotes, using '0' instead of 'False'... And I'm still feeling really stuck!

Thanks, everyone!

 

[RainbowGurl44]

To clarify, it's the

Set RepairListFirst = Application.Match(ATA.Value), Range("RepairListRange"), False)

line that it's getting stuck on.

Thanks!

 

[RainbowGurl44]

So, coming back to it the next day, I found that there were layers to the issue! I fixed one of them: The sub wasn't using the Public declarations that preceded it, so nothing was actually getting defined. But upon fixing that (I think!), now I'm getting an "Object Required" error for the same line. Let me know if more information is required! Thanks!