+ Reply to Thread
Results 1 to 8 of 8

Matching Entire Cell Contents Macro

  1. #1
    Valued Forum Contributor
    Join Date
    03-03-2009
    Location
    UK
    MS-Off Ver
    Excel 2017
    Posts
    1,009

    Matching Entire Cell Contents Macro

    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.

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,517

    Re: Matching Entire Cell Contents Macro

    This should do it

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,517

    Re: Matching Entire Cell Contents Macro

    Or this Im not sure what you ment

    Please Login or Register  to view this content.

  4. #4
    Valued Forum Contributor
    Join Date
    03-03-2009
    Location
    UK
    MS-Off Ver
    Excel 2017
    Posts
    1,009

    Re: Matching Entire Cell Contents Macro

    Quote Originally Posted by mike7952 View Post
    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?

  5. #5
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,790

    Re: Matching Entire Cell Contents Macro

    Hi,

    Substitute

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

    for

    If r.Value = "Total Length" Then
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  6. #6
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,517

    Re: Matching Entire Cell Contents Macro

    maybe this

    Please Login or Register  to view this content.

  7. #7
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,517

    Re: Matching Entire Cell Contents Macro

    Or this maybe better

    Please Login or Register  to view this content.

  8. #8
    Valued Forum Contributor
    Join Date
    03-03-2009
    Location
    UK
    MS-Off Ver
    Excel 2017
    Posts
    1,009

    Re: Matching Entire Cell Contents Macro

    Thanks again Mike!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1