ThisWorkbook Function breaks within "For" statement

[Wamhoi]

Hi, I keep getting a break referring to "ThisWorkbook". Can anyone help?

For i = 2 To lastline
    Columns("AL").Replace _
    What:=ThisWorkbook.Sheets("Metric").Cells(i, 1),   Replacement:=ThisWorkbooks.Sheets("Metric").Cells(i, 2), _
    LookAt:=xlWhole, MatchCase:=False
Next

 

[Andrew Poulsom]

You have ThisWorkbooks.

 

[Wamhoi]

Ah thanks! what a silly mistake on my part.