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

Thread: Issue with copy paste code
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,815
    Post Thanks / Like
    Mentioned
    48 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Issue with copy paste code

    If it's not activating at all, then the value in the cell isn't exactly 'Other' - note that VBA will not treat Other, other and OTHER as equal.

  2. #12
    Board Regular
    Join Date
    Jun 2019
    Posts
    104
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Issue with copy paste code

    Quote Originally Posted by RoryA View Post
    If it's not activating at all, then the value in the cell isn't exactly 'Other' - note that VBA will not treat Other, other and OTHER as equal.
    I triple checked and still no luck. I checked the name and copied and pasted that to make sure. I did the other thing you recommended as well.

  3. #13
    Board Regular
    Join Date
    Jun 2019
    Posts
    104
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Issue with copy paste code

    Is there a macro to make search cells in a certain range and clear if "Other" is found?
    Last edited by ERed1; Jul 19th, 2019 at 11:43 AM.

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
  •