MrExcel Publishing
Your One Stop for Excel Tips & Solutions

help with end(xlup)


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

Hi

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

Hi

You can also use SpecialCells method.

MsgBox ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row