Results 1 to 6 of 6

Thread: Can't populate Word VBA Combobox Value with last cell from xldown error

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Shouldn't this line
    LastRow = appExcel.Cells(1, appExcel.Row.Count).End(appExcel.xlDown).Row
    be
    LastRow = appExcel.Cells(appExcel.Rows.Count, 1).End(appExcel.xlUp).Row
    The row count is in the column parameter, and of course xlUp should be used.
    EDIT: also Rows.Count
    Last edited by jdelano; 03-08-2024 at 03:17 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •