Help: Loop through drop down list and create pdf files VBA close but not working....

[PowRider]

Hi experts,
I have a very similar situation to this post http://www.mrexcel.com/forum/excel-...hrough-drop-down-list-creating-pdf-files.html
I successfully use the code posted in that thread referenced to create a file for each item in the dropdown list.
PROBLEM:
My dropdown list is "store number" which are stored as text (eg 00202).
I believe when the code loops through, it changes the validation list from text to numbers and resulted in the data not updating.
In other words, every file came up to have blank cells/charts.
Please help me solve this.

Thanks!!

 

[Domenic]

Simply format the cell containing your dropdown list as "Text". Alternatively, you can add an apostrophe to the beginning of the string entered in the cell...

        For Each c In inputRange
        
            Range("AD5").Value = [COLOR=#ff0000]"'" & [/COLOR]c.Value
       
            'etc
            '
            '
               
        Next c

Hope this helps!

 

[PowRider]

big thanks!!!

 

[Domenic]

You're very welcome!

Cheers!