Thread: StrikeThrough
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default StrikeThrough

If Range("A1").Value = Range("B1").Value And _
Range("A1:B1").Font.Strikethrough = True Then
MsgBox "OK"
End If

Mike F
"Ben" wrote in message
...
Hi,

How to I check whether there is any striketrough on the text in one cell
with another text in another cell example:
column: a b

at at

where the two text are strikethrough. Note that the text must also be

matched.

thank.

regards,
Ben