MrExcel Publishing
Your One Stop for Excel Tips & Solutions

help with end(xlup)

Posted by Frank on December 20, 2001 4:11 PM


I know I can use range("A65536").end(xlup).select to find the last row with data in a column, but is there a quick way to find the lowest row for several columns. For example I have 20 columns and they all may have different lowest rows. I need to know the lowest row so I can place more data without overwriting the old data. Thanks for the help.

Posted by Colo on December 20, 2001 6:03 PM


You can also use SpecialCells method.

MsgBox ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row