Possible to create a macro that changes formulas?

[MickFlanagen]

Good Morning,

I have an excel sheet that uses the Bloomberg Ad-in. We need this sheet to be "live" (which uses one formula) and historical (a different formula)

the two formulas look like this:

Live: =BDP("ticker","px_last")
Historical: =BDH("same ticker","px_last",date,date)

*all of the things in italics are cell references, and the formulas are all in one row

So here is what I'd like to create a macro for:

Once I no longer need the sheet to be "live" (using the BDP formula), it like to have a macro that converts it to historical (using the BDH formula).

I know I can use a find and replace macro to change the first bit (BDP to BDH), but how do I get it to add those two "date" references to the end?

Thanks in advance for the help, I hope this makes sense.

MF