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

--
Regards,
Tom Ogilvy

"teresa" <teresa@discussions.microsoft.com> wrote in message
news:085605D3-7639-48E9-A167-21C8B043786A@microsoft.com...
> 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
>
>
>