Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I work with a spreadsheet staffing roster and I use VBA to copy and format information from the roster to other spreadsheets. People who maintain the roster enter names of planned vacation or training and if these don't take place they change the font to strikethrough afterwards. There may be more than one name in a cell so I often get something like: Smith / Jones with Jones in strikethough Within my VBA procedures I'd like to identify the strikethorugh characters and delete them so in the above example I'd just copy 'Smith' to another spreadsheet. TIA for any help or suggestions |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Check boxes and text strikethrough / color change | Excel Worksheet Functions | |||
Need to remove text with strikethrough - Excel 2007 | Excel Worksheet Functions | |||
Strikethrough Text to be identified with code | Excel Programming | |||
Strikethrough Text to be identified with code | Excel Programming | |||
Finding & deleting cells that do not contain a certain text string | Excel Programming |