Delete values with Strikethrough

[ThrottleWorks]

Hi,


I have a datafile, in column C I have names of customers.


These names can be in hundreds, some of the names are "Strikethrough" (Format Cells, Font, Effects).


I am am not supposed to work on values marked with strickethrough.


Can anyone please tell me how can I delete values with Strikethrough.

I tried hard but could not think of any solution.

 

[Marc L]

Hi !

[pre]

Sub Test()
For Each Cel In Columns(3).Cells
If Cel.Font.Strikethrough Then Cel.Clear
Next
End Sub

[/pre]

 

[Faseeh]

Hi sachinbizboy,


Does this help you: http://www.ehow.com/how_8653028_cells-strikethrough-excel.html


Regards,

 

[ThrottleWorks]

Hi Faseeh Sir & Marc Sir, thanks a lot for your help.


Have a nice day.