Matching Entire Cell Contents Macro

**ScabbyDog** · 02-23-2013, 05:16 PM

How can I adjust the below so that when it looks for "Total Length" it doesn't have to match entire cell contents?

Please Login or Register  to view this content.

**mike7952** · 02-23-2013, 05:22 PM

This should do it

Please Login or Register  to view this content.

**mike7952** · 02-23-2013, 05:24 PM

Or this Im not sure what you ment

Please Login or Register  to view this content.

**ScabbyDog** · 02-23-2013, 05:27 PM

Originally Posted by mike7952

Or this Im not sure what you ment

Please Login or Register  to view this content.

This is the one I want. And how do I change it so it just looks in column A?

**Richard Buttrey** · 02-23-2013, 05:29 PM

Hi,

Substitute

If InStr(r, "Total Length") > 0 Then

for

If r.Value = "Total Length" Then

**mike7952** · 02-23-2013, 05:34 PM

maybe this

Please Login or Register  to view this content.

**mike7952** · 02-23-2013, 05:38 PM

Or this maybe better

Please Login or Register  to view this content.

**ScabbyDog** · 02-23-2013, 05:39 PM

Thanks again Mike!

Re: Matching Entire Cell Contents Macro