+ Reply to Thread
Results 1 to 3 of 3

DropDown Additem adding blanks?

  1. #1
    Registered User
    Join Date
    01-30-2013
    Location
    Kansas
    MS-Off Ver
    Excel 2007
    Posts
    30

    DropDown Additem adding blanks?

    I'm in Sheet2 attempting to add items from Sheet1 to my DropDown I've just created, using the following code:

    Please Login or Register  to view this content.
    And it's just throwing empty strings into my DropDowns, why? and how can I fix this?
    If I have assisted you, please add to my Rep

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: DropDown Additem adding blanks?

    are your values in row 2 or column B? if they're in column B you need cells(x, 2) and not cells(2, x)
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    01-30-2013
    Location
    Kansas
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: DropDown Additem adding blanks?

    HAHAHAHAHA DUHHH. Wow sleep deprivation has ruined me. Many thanks and a rep to you my man.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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