Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel 2002 Replace "No format set" reformats entire cell anyway
All, I received a helpful answer from the MS Excel Misc newsgroup, which cited KB article 214346 ("XL2000: Rich Text Formatting Is Lost When You Use Replace All"). The article says that it applies to Excel 2000 but it seems to apply to XP as well -- perhaps even more broadly, as it is...- grogro
- Post #2
- Forum: Microsoft: Office
-
Excel 2002 Replace "No format set" reformats entire cell anyway
Hi, As my subject says ... In Excel 2002, when I have bold and non-bold text in the same cell, and I do a Replace of a word or phrase of the non-bold text, the entire cell gets formatted non-bold ... or sometimes as bold! This looks like a bug to me. Since it happens the very first time I use...- grogro
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Using Bessel Functions in Visual Basic
Dear Bomber1, Not all worksheet functions are available to Visual Basic. For a list of the ones that are, enter "list of worksheet functions available to visual basic" into the Answer Wizard in VB Help. A workaround is to enter the values and formulas into cells: c1.Value = x...- grogro
- Post #2
- Forum: Microsoft: Office
