Hi. I've manage to create a macro to change a text of a cell in several sheets. The problem is that this workbook i have has 365 sheets started by TT followed by another sheets, but the ones it mathers are the ones started as TT. Now i managed this macro
Sub Change_Text_String()
ScreenUpdating = False
Sheets("TT1").Select
Range("D1").Select
ActiveCell.FormulaR1C1 = "Medium"
Sheets("TT2").Select
Range("D1").Select
ActiveCell.FormulaR1C1 = "Medium"
Sheets("TT3").Select
Range("D1").Select
ActiveCell.FormulaR1C1 = "Medium"
Sheets("TT4").Select
Range("D1").Select
ActiveCell.FormulaR1C1 = "Medium"
Sheets("TT5").Select
Range("D1").Select
ActiveCell.FormulaR1C1 = "Medium"
ScreenUpdating = True
End Sub
and put the screen updating so its faster, but i have to write down the same piece of code for each one of the 365 TT sheets which is quite boring. I know there is a way to say in VBA something like For each ws. in this workbook started as "TT*" at this range do this, but dont know how to write it. By the way the range is always the same and all i want is to make a massive change of a cell text thats all.
Thank you
Bookmarks