Switch macro

[drakaz]

Hi,

I tried to google it, but all I can find is simple things that doesn't work for me and I'm no where near vba literate, so would greatly appreciate your help with this.

Giving example file probably won't do any good so I'll try to explain it: all I want is a "0", "1" value input extend formula. There are basically two bloomberg formulas, first:
=BDP($D5&" EQUITY",$A$19,$A$9,E$4&" Equity",$A$12:$A$14,$B$12:$B$14)
and second, which is taking A12:A15 and B12:B15 instead of 14
=BDP($D5&" EQUITY",$A$19,$A$9,E$4&" Equity",$A$12:$A$15,$B$12:$B$15)

Yet, these formulas repeat ~200 times, so the switch should be able to change values in all of them, A12:B14 and A12:B15 are static and will not change positions for all of them.

Thank you again for your help.