Identifying Top row
 

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

Identifying Top row
 

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

--
Regards,
Tom Ogilvy

"teresa" wrote in message
...
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

Identifying Top row
 

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

Doesn't do it; if you want the first row in Column A to control try

Range("Y" & Range("A1").End(xlDown).Row).Value = "GM"

If you want Column B to control, change the A1 to B1

Alan Beban

Identifying Top row
 

Thanks, misread the question.

--
Regards,
Tom Ogilvy

"Alan Beban" wrote in message
...
Tom Ogilvy wrote:
Range("Y" & Cells(Rows.Count, 1).End(xlUp).Row).Value = "GM"

Doesn't do it; if you want the first row in Column A to control try

Range("Y" & Range("A1").End(xlDown).Row).Value = "GM"

If you want Column B to control, change the A1 to B1

Alan Beban

Identifying Top row
 

"Alan Beban" wrote...
....
Doesn't do it; if you want the first row in Column A to control try

Range("Y" & Range("A1").End(xlDown).Row).Value = "GM"

If you want Column B to control, change the A1 to B1

Doesn't work if A1 (or B1) is the only nonblank cell in its column. And if
A1:A# were all nonblank, this would give the bottommost row in that range of
nonblank cells.

If col A should control, shouldn't this be

Range("Y" & IIf(IsEmpty(Range("A1").Value), _
Range("A1").End(xlDown).Row, 1)).Value = "GM"