+ Reply to Thread
Results 1 to 3 of 3

Find and Highlight specific numbers

  1. #1
    Registered User
    Join Date
    01-22-2009
    Location
    Worcester, England.
    MS-Off Ver
    Excel 2003
    Posts
    5

    Find and Highlight specific numbers

    Hi, I have a spreadsheet with a stock list. Each item has an individual number.
    I have a code below, which I have doctored from other various sources (thanks to them). The problem I have is that if I search for number '12' the spreadsheet highlights every cell with 12 in (120 121 122 123 etc...)
    Is there any way I can change the code so that it returns only the 12 and not every cell that contains 12? Any help from you VBA / Excel guru's will be very much appreciated.

    The current code is as follows:
    Please Login or Register  to view this content.
    Last edited by RWheldon; 01-22-2009 at 07:35 AM.

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606
    Amend the Find line:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-22-2009
    Location
    Worcester, England.
    MS-Off Ver
    Excel 2003
    Posts
    5
    StephenR you are a genious! many thanks for the quick reply!

    Problem solved.

+ 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