Excel VBA使用户选择的范围变量永久

I have a script that is converting a Julian Date to a Gregorian Date. I am supposed to be able to click on a range that contains my Julian Date, then select on a range where I'd like to insert my Gregorian Date. The only problem is that once I set the first selected range as JD (Julian Date), I can't seem to assign a new selected range. I have a script that is converting a Julian Dat