Results 1 to 5 of 5

Changing array names creates error

Threaded View

  1. #1
    Registered User
    Join Date
    08-07-2004
    Location
    Colorado
    MS-Off Ver
    365
    Posts
    62

    Changing array names creates error

    I was looking for some parts to build a form and found one that's almost what I need - thanks mehmetcik. What I'm having an issue with is that the array can be renamed and still work just fine, but changing the list items causes an error. In the examples the first two run just fine (as long as all references to the array are changed also) but the third example causes an error and I am at a loss as to why. The problem workbook is attached.



    MyNames = Array("Employee", "Equipment", "Part", "Defect", "Lot")
    MyOtherNames = Array("Employee", "Equipment", "Part", "Defect", "Lot")
    MyNames = Array("Somebody", "SomeEquipment", "Part", "Defect", "Lot")
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need help on macro that creates two Workbooks with custom file names
    By joshuarobbins in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2015, 01:27 PM
  2. Changing Sheet Names based on cell value - Object doesnt support this property error
    By joshnathan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-26-2013, 09:30 AM
  3. Modify VBA code that creates a list of Sheet Names
    By Coleen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-30-2013, 01:41 PM
  4. [SOLVED] A Macro that creates hyperlinks by matching the names of a column
    By kc07 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-02-2012, 04:17 AM
  5. Workbook A creates B & uses worksheet names from A in B
    By dkub in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-13-2011, 12:04 PM
  6. Array Formula creates error if too may cell chosen
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-29-2006, 07:25 PM
  7. Replies: 4
    Last Post: 05-04-2005, 12:06 PM

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