| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
partially replace formula problem. Please help!
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF in between rows | Excel Worksheet Functions | |||
| automate replace values in formula | Excel Discussion (Misc queries) | |||
| conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
| formula percentage problem | New Users to Excel | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Threaded Mode
