Hi,

I need some help with something I am trying to do with a spreadsheet. I have a workbook with 41 sheets in it and I need to change a formula that is in 20 of the worksheets (they all have the same format) which can be reference by codename - this is from another code I have running on the same workbook:
Please Login or Register  to view this content.
.
There are specific cells that the formula is in which are "B6:N12", "B15:N21", "B24:N30", "B33:N39", "E44:K44"

The Code that is in B6 for example is:
Please Login or Register  to view this content.
I want to change all the cells to be 
Please Login or Register  to view this content.
where the B4 changes depending on cell. I can't do a Replace All because of the "B4/C4" being different in each cell.

I have attached a sample of the format I'm working with:
rotatest10.xlsx