Results 1 to 3 of 3

Thread: find and highlight VBA
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Apr 2011
    Posts
    208
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default find and highlight VBA

    Im looking for a bit of code to search for whats in cell C27 and highlight each cell that matches it, with a colour eg yellow
    the problem is that the contect of C27 is a formula ''='Issue - Weekly'!A1'' which has result of ''DInger'' and the rest of the sheet is also formula based

    so its not as easy as searching for DInger , you have to search for the result of ''='Issue - Weekly'!A1

  2. #2
    Board Regular
    Join Date
    Apr 2004
    Posts
    7,895
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: find and highlight VBA

    how big is your searchable range?
    Yesterday I felt on top of the world. Today its falling in on me.

  3. #3
    Board Regular
    Join Date
    Apr 2011
    Posts
    208
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: find and highlight VBA

    Quote Originally Posted by steveo59l View Post
    how big is your searchable range?
    a1:cc80

Some videos you may like

User Tag List

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
  •