A possible solution is a Combobox on your worksheet filled with all available currencies in which you first select the desired CCY and then refer to that selected value in your macro instead of hard-coding your CCy in your code.