Solved How to bold a commonly occurring word for 1000 rows in excel

December 19, 2016 at 03:57:52
Specs: Windows 7
Hi, i have a little different scenario where i have written small passages for 1000 rows. In which i have a common word "Note" which i need to bold and underline for all 1000 rows. can suggest me any short cut to do this?

See More: How to bold a commonly occurring word for 1000 rows in excel

Report •

#1
December 19, 2016 at 06:07:44
✔ Best Answer
The VBA code found here will bold all occurrences of the word that you enter in the input box:

http://excel.tips.net/T002414_Makin...

By adding this instruction after the instruction that applies the bold formatting, the text will be underlined also:

.Characters(iFind, iLen).Font.Underline = True

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question