For j = Cells(Rows.Count, "A").End(xlUp).Row To 6 Step -1

i know about the for loop, im just not sure about the xlUp stuff. thanks

Cells(Rows.Count, "A").End(xlUp).Row
will get you to the last row in col A from the bottom up. With many macros,
especially those that delete rows it is best to work from the bottom up. so
you start at the bottom and look at each row above
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Jim" <Jim @discussions.microsoft.com> wrote in message
news:0FDE8C98-DA72-4350-A063-(E-Mail Removed)...
> For j = Cells(Rows.Count, "A").End(xlUp).Row To 6 Step -1
>
> i know about the for loop, im just not sure about the xlUp stuff. thanks

It just determines the last filled row by working from the (very) bottom row
up.

--
__________________________________
HTH

Bob

"Jim" <Jim @discussions.microsoft.com> wrote in message
news:0FDE8C98-DA72-4350-A063-(E-Mail Removed)...
> For j = Cells(Rows.Count, "A").End(xlUp).Row To 6 Step -1
>
> i know about the for loop, im just not sure about the xlUp stuff. thanks

cells(row.count, is the number of rows on the sheet (65536 on xl 2003).
the end(xlup) moves to the first populated cell in column A - it's going
from the bottom of column A up, getting to the bottom of populated cells in
col A (same as [ctrl] + [up arrow key]).
counting from the bottom row to row 6 (numerically counting down from the
last row to row 6)...
--
MacGuy

"Jim" wrote:

> For j = Cells(Rows.Count, "A").End(xlUp).Row To 6 Step -1
>
> i know about the for loop, im just not sure about the xlUp stuff. thanks