I have been trying to create a VBA from command button that allows me to print all from a drop down list (one sheet per item on the drop down list). I am at this point but have an error and can't figure it out.
Any help greatfully received
Private Sub CommandButton1_Click()
Sub...