MrExcel Publishing
Your One Stop for Excel Tips & Solutions

last column used

Posted by Neil Bhatia on December 20, 2001 4:54 AM

I am trying to get the last column used by excel
I can get the last row used by using


So I thought I would try using


However that doesnt work, any help would be much appreciated

Posted by Mudface on December 20, 2001 4:59 AM

Try : -

x = ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Columns (or .Rows for the row).

Posted by Mudface on December 20, 2001 5:07 AM

Ooops, that'll give you the value in the cell, try .Column or .Row to return the column or row number.

Posted by Campeius on December 20, 2001 6:26 AM