Read cell value and display
 

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

Read cell value and display
 

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

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