locked
VBA .LastRow - Object doesn't support this property or method RRS feed

  • Question

  • Could you please help me understand why the error ?

    I would really like to use the absolute path to the Sheet object in order to avoid '...object defined...' error.



    God bless you all :)

    Wednesday, June 1, 2016 11:33 AM

All replies

  • This should work.

      xRow = ActiveWorkbook.Sheets("Sheet1").Cells.SpecialCells(xlCellTypeLastCell).Row
      xColumn = ActiveWorkbook.Sheets("Sheet1").Cells.SpecialCells(xlCellTypeLastCell).Column
    

    Wednesday, June 1, 2016 12:53 PM