View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default Read cell value and display

Hi Tom,

Below is the example.

example: column a b c d

text reboot Text is strikethrough in
column a
try text Text is strikethrough
in column b

where text is strikethrough.

thanks
regards,
Ben

"Tom Ogilvy" wrote:

How about an example of what you mean by only show the cell value?

Do you want to hide rows that contain a strikethrough or something like
that?

Is all the text in the cell formatted for strikethrough or only some letters
within a string?

--
Regards,
Tom Ogilvy

"Ben" wrote in message
...
Hi,

How to I use vba to read the range of cell value in one column and based

on
the font strikethrough condition, i only show the cell value?


thanks.

regards,
Ben