Check matching value
 

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

Check matching value
 

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.

On Thu, 4 Nov 2004 18:32:01 -0800, Ben wrote:

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