i got this from tek-tips forum but i can't seem to get it working... do
i have to add anything? i'm pretty new at coding so i'm still
learning...

what i'm basically trying to do is this:
i have col A - R
they're all different lengts... some are the same but usually there's
one or 2 which are usually the longest... like, A might only be through
row 17, but C may be all the way through 34, and so on... all i need is
something that will find the longest column, go 3 cells down from that
and select A# (# being the last row + 3)

Sub FindLastRow()
r = ActiveSheet.UsedRange.Rows.Count
c = ActiveSheet.UsedRange.Columns.Count
LastRow = ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell) .Row
End Sub


---
Message posted from http://www.ExcelForum.com/