stpath = "R:\SPM\Horis Info\Horis_Project\GBM\Jan-15\Output\Europe\All"
I want the region Europe to toggle, so on the excel spreadsheet I have a dropdown on cell M5 - how do I reference the cell M5 as opposed to hardcoding the vbal code with "Europe"
The same applies to a line I have
stfilename1 = str & " GB-Corp (Jan-15) - Managed Region .pdf"
Where it says GB-Corp I would like the cell N5