Hi guys first post and very much not an expert in Excel Macros
I have a macro that is used by an organisation (A). Another organisation (B) is wanting to use the macro and the wording on the spreadsheets is different by 1 word
Organisation A uses - "MYWAY BREAKFAST"
Organisation B uses - "MYWAY"
The original Macro for Organisation A will auto populate a spread sheet and any instances of the words below will turn green:
"Breakfast Inclusive"
"Myway Breakfast"
"Voucher 1"
"Voucher 2"
I figured I would just be able to change "Myway Breakfast" to "Myway" and this would work instantly however the following happens
-The 4 keywords still auto populate as needed (GOOD)
- ONLY "Breakfast Inclusive" now turns green and the other 3 keywords dont change color (BAD)
Code is below after I edited to just be "MYWAY"
Any help would be greatly appreciated! YOU DA BEST!
------
End Sub
Bookmarks