I have a whole bunch of formula with some parts similar like
€œMVJan!$A$13:$Z$68€� in about 12 worksheets, but Feb will change
MVFeb!$A$13:$Z$68 and so on.

Now I want these similar formula to be placed as
€œINDIRECT("MV"&mth&"!$A$8:$Z$18")€� mth is defined name to define the cell
that I can change the month and reference area will be changed.

The problem now is that reference area is not always the same. $A$13:$Z$68
can be $A$35:$Z$177, etc.


How can I replace this kind of formula in a batch? Whats kind of code
should I use? Can I use object?


Your help is really appreciated!


Thanks