Check matching value

[Guest]

Hi,

How can i check that a value in one cell with respect to a range of cells
that the value/text is found in the range and vice versa and that the font in
the cell has a strikethrough font.

thanks.

regards,
ben

 

[Myrna Larson]

For the first question, use Application.MATCH or Application.VLOOKUP (syntax
for either is the same as for the worksheet functions), or VBA Find.

For the font, look up the Font object in VBA Help. You'll see it has many
properties, one of which is StrikeThrough.