When on a given cell in a s-sheet, just not in row 1 where the headers are. For this example cell Z10.
How would on write a Do While there is a value in row 1 of column Z??? that would work just the same if I was in cell AA10? Goal is do while there is a value in row 1 of whatever the active cell is.