I was recommended by Carim to start a new thread on this after I posted in an old thread. I am trying to write an an Index Match function that looks across worksheets. Essentially the index match is taking a list of values from sheet 2 and then cross-referencing and pulling values from sheet 3. I am getting a compile error because it expects and end of statement and I might be blind but I can't see what's wrong. This is the piece of code that i'm referring to:
Dim LastRow As Integer Dim RR As Variant Dim VR As Variant RR = Worksheets(3).Range("a:a") VR = Worksheets(3).Range("am:am") LastRow = .Cells(Rows.Count, 1).End(xlUp).Row For x = 25 To LastRow cells (x,"ao") = "=INDEX(VR,MATCH(cells(x,"a"),RR,0))" Next x
For some reason I can't attach the workbook. I'll keep trying...thanks again for everything.