Results 1 to 19 of 19

Stupid Input Box Error 2015

Threaded View

  1. #6
    Registered User
    Join Date
    04-29-2011
    Location
    islip, ny
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: Stupid Input Box Error 2015

    I just confirmed the problem is with the inclusion of

    ActiveWorkbook.Sheets(1).Select
    sheett1 = ActiveSheet.Name
    ActiveWorkbook.Sheets(2).Select
    sheett2 = ActiveSheet.Name
    ActiveWorkbook.Sheets(3).Select
    sheett3 = ActiveSheet.Name
    ActiveWorkbook.Sheets(4).Select
    sheett4 = ActiveSheet.Name
    ActiveWorkbook.Sheets(5).Select
    sheett5 = ActiveSheet.Name
    ActiveWorkbook.Sheets(6).Select
    sheett6 = ActiveSheet.Name
    ... I just want to list the worksheet names in my dialogue box, any ideas on how to do that?

    OK I've clearly identified it as a problem with 'list separators' :

    "1 - " & sheett1 & vbNewLine & _
    -- the way the &'s are used with trying to include the defined worksheet name
    Last edited by tomn13; 11-02-2012 at 12:57 PM.

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