ISNA Formula syntax in VBA

[Anne Troy]

Simply cannot figure out what's wrong. Debug just highlights the whole line. I forget when/where I need double quotes... THANKS!!

Oh, and I just need the formula!

Sub GetZips()
Dim LastRowColumnA As Long
LastRowColumnA = Cells(Rows.Count, 1).End(xlUp).Row
Range("B2:B" & LastRowColumnA).Formula = "=ISNA(VLOOKUP(A2,datatable,2,0),"Not Found",VLOOKUP(A2,datatable,2,0))"
End Sub

 

[Peter_SSs]

365!

If you add it to your account details it is always visible like this so you don't have to remember to provide the information each time.