Hi, Im Pablo, I have a Workbook named "recepies", and this workbook has 90 sheets and all with diferent names: "cost", "sales", "cheescake", "math", "key lime pie", "red velvet", etc...
sometimes I need to replace text in several sheets (not all of them) just a selection (like 80 sheets) and if I use the excel opcion find/replace text or numbers, the value is Replace in all sheets or only in the sheet im working. Im looking for a VBA code to do this:
sometimes I need to replace text in several sheets (not all of them) just a selection (like 80 sheets) and if I use the excel opcion find/replace text or numbers, the value is Replace in all sheets or only in the sheet im working. Im looking for a VBA code to do this:
Last edited by a moderator: