Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: VBA. Delete row in a range if Values in Column A do not equal Cell B2

  1. #11
    Board Regular James_Latimer's Avatar
    Join Date
    Jan 2009
    Location
    Sheffield, UK
    Posts
    414
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA. Delete row in a range if Values in Column A do not equal Cell B2

    Can you please post what worked so that anyone in future can see what the solution was? Thanks mate, glad its working for you!

  2. #12
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,177
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: VBA. Delete row in a range if Values in Column A do not equal Cell B2

    Both codes should work.
    I'm thinking along on the same lines as James.
    In a blank cell enter =LEN(B2)
    & in another blank cell enter =LEN(A7) Pointing to a cell that = B2
    Do both formulae give the same results?
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #13
    New Member
    Join Date
    Jun 2018
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA. Delete row in a range if Values in Column A do not equal Cell B2

    They both worked, I went back and did a thorough check, I'd added an extra space in between a first and last name!
    It is really appreciated, saved me from going completely crazy!

  4. #14
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,177
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: VBA. Delete row in a range if Values in Column A do not equal Cell B2

    Glad you got it sorted & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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