Find and Highlight a group of numbers

**Krazy Kasper** · 08-28-2008, 02:43 PM

have a macro that finds and highlights a number (Using the find and replace function). Now I need to expand it to find and highlight a group of numbers (I can paste them into the macro or VBA code) against the numbers in column A. I know there is a way, possibly using case logic or looping but need some help as I am a novice with VBA. Here's what I have in the macro so far:

Please Login or Register  to view this content.

**yawnzzzz** · 08-28-2008, 03:19 PM

What numbers are you trying to look for?

Also, are you looking for patterns or just individual numbers?

**Leith Ross** · 08-28-2008, 04:17 PM

Hello Krazy Kasper,

To make your posts easier to read and preserve your formatting, please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
On the Message window Toolbar you will see the # icon. This will automatically wrap the text you selected with the proper HTML tags to create a Code Window in your post. You can do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.

As a new member please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the link below...

Forum Rules

Sincerely,
Leith Ross