+ Reply to Thread
Results 1 to 2 of 2

Print all options from dropdown list to PDF and name the files the exact names in the list

  1. #1
    Registered User
    Join Date
    10-07-2014
    Location
    escondido
    MS-Off Ver
    2016
    Posts
    10

    Angry Print all options from dropdown list to PDF and name the files the exact names in the list

    Hi all,
    this is my first post and I would greatly appreciate any help. I have been successful in running a macro that will print all of the options from the drop down list but then it requires me to name the files myself.....problem is I don't know which option is printing to give it a specific identifiable name. I would love for it to use each of the names from the list as the file name. Any help would be greatly appreciated. My list is in cell B2.

  2. #2
    Registered User
    Join Date
    10-07-2014
    Location
    escondido
    MS-Off Ver
    2016
    Posts
    10

    Re: Print all options from dropdown list to PDF and name the files the exact names in the

    ....This is what I have that works great, but doesn't use the names from the list options as the file name......which is what I need
    Sub PrintAll()
    Dim strValidationRange As String
    Dim rngValidation As Range
    Dim rngDepartment As Range

    ' Turn off screen updating
    Application.ScreenUpdating = False

    ' Identify the source list of the data validation
    strValidationRange = Range("b2").Validation.Formula1
    Set rngValidation = Range(strValidationRange)

    ' Set the value in the selection cell to each selection in turn
    ' and print the results.
    For Each rngDepartment In rngValidation.Cells
    Range("b2").Value = rngDepartment.Value
    ActiveSheet.PrintOut
    Next

    Application.ScreenUpdating = True
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 03-18-2014, 02:19 PM
  2. Remove selected options from dropdown list
    By Badking333 in forum Excel General
    Replies: 15
    Last Post: 11-26-2013, 10:49 PM
  3. Replies: 2
    Last Post: 08-05-2013, 10:08 PM
  4. Cull dropdown list options based on selection in another dropdown
    By Kiffar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2012, 01:53 AM
  5. Dropdown list options
    By Back2Basics in forum Excel General
    Replies: 4
    Last Post: 02-10-2009, 10:04 AM

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