Hi, I keep getting a break referring to "ThisWorkbook". Can anyone help?
For i = 2 To lastline
What:=ThisWorkbook.Sheets("Metric").Cells(i, 1), Replacement:=ThisWorkbooks.Sheets("Metric").Cells(i, 2), _
Any help on this would be appreciated - I have a suspicion this is a pretty basic question (at least I hope it is).
I have a formatted spreadsheet with unique identifiers for each row (unique identifier is in its own column). However one column of data is incorrect and needs to be replaced...