Coding Macro

[JonnyNismo]

In this macro, I,m having trouble figuring out how to reference the column to the right with out having to maually enter the location ie. AP2

Sub CodeBank()

[Z1].Formula = "=IF(ISNA(VLOOKUP(AP2,Lookup!Company,2,FALSE)),"""",VLOOKUP(AP2,Lookup!Company,2,FALSE))"

[Z1].ClearContents

End Sub

Any help would be greatly appriciated,

Thank you

 

[Joe Was]

ActiveCell.OffSet(0, 1)

 

[Greg Truby]

Use R1C1 notation?