Get rid of the "(Offset(0, -1)"

    Sheets("Pivot Table").Select
    Rows("3:3").Select
    Selection.Find(What:="Period").Select
    Selection.Select
    ActiveCell.Offset(1, 0).Select
    Range(Selection, Selection.End(xlToRight)).Select