ExcelBanter - Change text in rectangle shape

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Change text in rectangle shape (https://www.excelbanter.com/excel-programming/381697-re-change-text-rectangle-shape.html)

Carole O

Change text in rectangle shape

Have you tried Edit, Find, Replace?

"Finance guy" wrote:

How can I enumerate through all worksheets and rectangles and add a text
string to all textboxes all of them currently say ©2006 I need to change
it to 2007.

All times are GMT +1. The time now is 05:36 PM.