MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to find a cell with underlined text in it (in xlm)

Posted by Karl Lambermont on January 03, 2001 3:02 PM

I'm currently struggling in finding a possibility to clean up a large database. The intent is to group the database. The group header is always underlined (text format).
Is there an easy way to find cells that contain underlined text?

If so, | can use this to build a macro to automate the grouping. I'm still using Excel 4.0 macro language, so | would appreciate a solution that can be programmed in this macro language.



Posted by cpod on January 03, 2001 3:35 PM



Returns true is text in cellref is underlined, false if not.