+ Reply to Thread
Results 1 to 2 of 2

Modify VBA Code Search Hilight from 1 range to multiples range?

  1. #1
    Forum Contributor
    Join Date
    10-21-2012
    Location
    miami, florida usa
    MS-Off Ver
    Excel 2007
    Posts
    260

    Modify VBA Code Search Hilight from 1 range to multiples range?

    Hi,

    i'm struggling with this modification..

    In row F1 i insert sets of 5 numbers e.i -> 1,2,3,4,5
    in Column J:5 down if any numbers that have numbers (from row F1), it get Highlighted in Red.
    Is working fine with one range.

    My Question is :

    Additional to J5, I need to Include Columns N5, R5, V5 down.

    P.S
    I modified the
    Please Login or Register  to view this content.
    But it give em Error 1004, or Method 'Range' of object 'Global' failed


    Please Login or Register  to view this content.


    Thank you



    Best Regards

    David
    Last edited by david gonzalez; 09-26-2014 at 04:12 PM. Reason: replace the word row by column

  2. #2
    Forum Contributor
    Join Date
    10-21-2012
    Location
    miami, florida usa
    MS-Off Ver
    Excel 2007
    Posts
    260

    Cool Re: Modify VBA Code Search Hilight from 1 range to multiples range?

    Hi All,

    The Way i done was as follow :
    I copy 4 times the code and adapt each range needed for each code

    Note:
    I forgot to mention that this Code was Done by a Brilliant VBA coder Mr. Jindon.
    I Requested only for 1 Range when he nicely did it for me, and this code has been
    Working So Perfect the way he did !!!!!!!!!!!!

    Please Login or Register  to view this content.
    Then i Called the Argument with one macro over a Macro,

    That's It !!

    Please Login or Register  to view this content.

    Thank You !


    Best Regards

    David
    Last edited by david gonzalez; 09-26-2014 at 11:50 PM. Reason: Add mention

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Modify this Search Formula to search across a range of cells
    By zicitron in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-16-2013, 08:11 AM
  2. How to modify Worksheet_Change Macro VBA code from Range to Cell
    By AGCSC1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2013, 04:23 PM
  3. Recorded Code/Modify/Convert Range to Dynamic
    By nuttycongo123 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-08-2011, 08:35 PM
  4. Modify code to change Sum Range
    By ker9 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-28-2010, 03:32 PM
  5. Modify code to drag cell contents across a row range
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-20-2010, 04:34 PM

Tags for this Thread

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