Printing sheet from list reference

[RhodEvans]

Morning, I am sure it is easy as I have done this before, but can't remember how or where I have put the code.I have a spreadsheet with multiple worksheets (The amount and names of sheets will keep changing). On a front sheet I have a dynamic validation list in cell "L9" that will always have the full list of spreadsheet names. The idea is that I will choose which spreadsheet to print from this list. Press a button and only that sheet will print. Any idea's, or any better Ideas on how to do it.You help and weath of knowledge is appreciated

 

[Sixthsense]

Try something like this...

Sub PrintSheetBasedOnDropDown()

With Sheets("ValidationSheetNameHere")
    Sheets(.Range(L9).Value).PrintOut Copies:=1, Collate:=True
End With

End Sub

 

[RhodEvans]

Thanks for the help, however on running the code, I get a '1004' Application-Defined or Object-defined error. The only thiing I can think of is: I have merged cells L9 & M9 together to make the validation drop down, does this make any difference to the code?Thanks again

 

[Sixthsense]

Oops cover the text L9 within double quotes like "L9"

 

[RhodEvans]

I should have noticed that!!! But, thanks. A nice bit of code, and I'm sure, far simpler than the one I used last time.