I've tried using Excel's Record Macro featrure to do this, but it doesn't seem to want to record the "Find" part.
I need to highlight columns B:D, find all instances of a word (in this case, "new"), and then perform the following:
1. Remove all borders
2. Add Bottom border.
Basically changing this:
I have a rather long VBA macro I use to format everything else, but this step is missing, and I was hoping I could sneakily slip a script in that would perform this last step.
I need to highlight columns B:D, find all instances of a word (in this case, "new"), and then perform the following:
1. Remove all borders
2. Add Bottom border.
Basically changing this:
I have a rather long VBA macro I use to format everything else, but this step is missing, and I was hoping I could sneakily slip a script in that would perform this last step.