Results 1 to 6 of 6

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

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-07-2024, 05:29 AM #3
    plifshits
    plifshits is offline
    VBAX Newbie
    Joined
    Mar 2024
    Posts
    4
    Location
    Quote Originally Posted by arnelgp View Post
    you started from the end of the Row (appExcel.Rows.Count), therefore you need to Go Up. use xlUp.

    ListItems = appExcel.Range(appExcel.Cells(1, 1), appExcel.Cells(appExcel.Rows.Count, 1).End(appExcel.xlUp)).Value

    Hi arnelgp,

    Unfortunately this does not help,
    Still receiving an error.
    Last edited by Aussiebear; 01-01-2025 at 02:43 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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
  •  

Forum Rules