You're right I could definitely shorten it down this is just a macro from a previous employee so I haven't really messed with it. Still does not solve the copying of text string "Test Slide Distribution" to the clipboard at the end however.