I have 20 rows,


if the first row is the 5th row e.g.A5 or B5,
then I want Y5 = "GM" ETC.ETC.

So something like:

Y(Cells(Rows.Count, 1).End(xlUp).Row)= "GM"

obviously not End(xlUp).Row but something similar

Thks