P Pubert Apr 1, 2004 #1 Is there a VBA Function that will give me the last used column and row? Or what suggestions does anybody have?
Is there a VBA Function that will give me the last used column and row? Or what suggestions does anybody have?
N Nigel Apr 1, 2004 #2 Courtesy of John Peltier in an earlier post........ This tells me the address of the highest nonblank cell in column C: Range("$C$65536").End(xlup).Address This tells you the row: Range("$C$65536").End(xlup).Row
Courtesy of John Peltier in an earlier post........ This tells me the address of the highest nonblank cell in column C: Range("$C$65536").End(xlup).Address This tells you the row: Range("$C$65536").End(xlup).Row
J John Williams Apr 1, 2004 #3 Pubert said: Is there a VBA Function that will give me the last used column and row? Or what suggestions does anybody have? Click to expand... lastRow = Cells(rows.Count, ActiveCell.Column).End(xlUp).row lastColumn = Cells(ActiveCell.row, Columns.Count).End(xlToLeft).Column
Pubert said: Is there a VBA Function that will give me the last used column and row? Or what suggestions does anybody have? Click to expand... lastRow = Cells(rows.Count, ActiveCell.Column).End(xlUp).row lastColumn = Cells(ActiveCell.row, Columns.Count).End(xlToLeft).Column
