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

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

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