View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
John Williams[_4_] John Williams[_4_] is offline
external usenet poster
 
Posts: 12
Default Last Row and Column

"Pubert" wrote in message ...
Is there a VBA Function that will give me the last used
column and row? Or what suggestions does anybody have?


lastRow = Cells(rows.Count, ActiveCell.Column).End(xlUp).row
lastColumn = Cells(ActiveCell.row, Columns.Count).End(xlToLeft).Column