Assuming column1 is Column A, and column2 is Column B, to find the last row
of Column A and Column B on Sheet1 (note I am using the code name for the
worksheet - if you want to use the sheet name use Worksheets("YourSheetName")

Sub test()
With Sheet1
MsgBox .Cells(.Rows.Count, 1).End(xlUp).Row
MsgBox .Cells(.Rows.Count, 2).End(xlUp).Row
End With
End Sub

"willz99ta via OfficeKB.com" wrote:

Howdy,

Im trying to load two different dynamic arrays with two different column's
data.

One column could be different in size than the other and either column could
be as large as 60000 or as small as one.

What could I use to find the last row of column 1 and then use to find the
last row of column 2. I am trying to fill out the array ranges.

Thanks,

Will

--
Message posted via http://www.officekb.com