If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
i have a series of 40 worksheets in a workbook.
Each worksheet contains a type of graph (bar chart) or table.
The titles of each graph and table are exactly the same on every worksheet.
I would like to replace the "2008" in all the titles on each worksheet without out having to manully got to each one individually and clicking on the chart and re-typing.
I tried selecting all sheets but this doesnt work.
I created a macro but I still can't populate it to all sheets by selecting all sheets.
finding and replacing text in charts
Linear Mode
