The given selection of cells contains all links to another file. The file name has the word "May" in it. I want to be able to update all these links each month from month to month and just edit, replace with the month names. The following code works to update all the links from May to June, but I want to put a couple dropdowns in the file and let the user select a "prior month" and "current month" and have the following code reference the text in those two cells instead of having the months hard-coded in the below code. Seems simple, but I've tried a couple things and am stumped. Any help would be great!
Range("F5:Q150").Select
Selection.Replace What:="May", Replacement:="June", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("F5:Q150").Select
Selection.Replace What:="May", Replacement:="June", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False