Sorry,
The workbook, sheet, and column remain constant, but the row changes. I am doing a search in Column A on "branch", when it is found, a marker is setup in AY, all rows above it are deleted, and code is activated based on that marker. Then branch is found again so the process...