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
&media=https%3A%2F%2Fwww.mrexcel.com%2Fimg%2Fmrexcel-publishing.png){kind=link}