Results 1 to 7 of 7

Listbox w/ Range.name rowsource only displaying 6 of the 8 range elements

Threaded View

jazaddict Listbox w/ Range.name... 09-28-2009, 11:48 PM
shg Re: Range.Count 8 .... List... 09-29-2009, 12:06 AM
jazaddict Re: Listbox w/ Range.name... 09-29-2009, 09:57 AM
shg Re: Listbox w/ Range.name... 09-29-2009, 11:05 AM
jazaddict Re: Listbox w/ Range.name... 09-29-2009, 12:24 PM
jazaddict Re: Listbox w/ Range.name... 09-29-2009, 03:41 PM
jazaddict Re: Listbox w/ Range.name... 09-29-2009, 05:06 PM
  1. #1
    Registered User
    Join Date
    09-28-2009
    Location
    Albuquerque
    MS-Off Ver
    Excel 2003
    Posts
    11

    Listbox w/ Range.name rowsource only displaying 6 of the 8 range elements

    Howdy.
    Kinda flumuxed here. I have a Range with 8 elements. (the number of elements will continually change and the range will be redefined to include all elements)
    WHen I do Range.Count I get 8.
    When I do a Range.select it highlights the 8 elements.
    WHen I set the listbox.rowsource to the range name I only get 6 of the elements.
    As the range grew the listbox correctly displayed elements 1-6 . Then at 7 Range elements & up I the listbox would ONLY display the first 6.

    Thoughts?

    Drivin me nuts.

    Excel 2003.
    Last edited by jazaddict; 09-29-2009 at 09:56 AM. Reason: because I was asked.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1