VBA Macro Needs to find Last Instance of in Range

**mansions2find** · 09-21-2015, 03:00 PM

I'm trying to write a macro that will take a range of values from sheet 2 and find each of those values LAST(most bottom-right) appearance in another defined range. Below is what I have at the moment. I want the last instances of the numbers to be highlighted. Let me know if you need any more details. Thanks in advance.

Please Login or Register  to view this content.

**PCI** · 09-21-2015, 03:14 PM

What is the issue with your code?
Perhaps just review the loops from the max to 1

Please Login or Register  to view this content.

BTW keep in mind to use code tags when posting code

**mansions2find** · 09-21-2015, 03:36 PM

I've only been able to highlight incorrect cells with this code. I tried that line you supplied me PCI, and the results are the same. I believe the issue is when i'm actually trying to select the cell that matches a value and then set the background color.

Please Login or Register  to view this content.

When I get through the loops and find the most bottom-right cell match in the range, I want to be able to select that matched cell. I don't think I am doing that correctly.

**PCI** · 09-21-2015, 04:05 PM

See next code
Adapt the ranges

Please Login or Register  to view this content.

**mansions2find** · 09-22-2015, 09:12 AM

Thanks! Works like a charm

**PCI** · 09-22-2015, 09:18 AM

You're welcome

**mansions2find** · 10-02-2015, 12:13 PM

Hey, Was hoping to clear up a little bit of confusion.... The bold line in the code below i believe is what finds the last instance of an ID. Could somebody explain to me how this IF statement checks for that appropriately?

Please Login or Register  to view this content.

**PCI** · 10-03-2015, 05:54 AM

The loop is scanning all cells
from the last row to the first one with:
For i = LastRng.Rows.Count To 1 Step -1
from the last column to the first one with:
For j = LastRng.Columns.Count To 1 Step -1

then if a cell is not Empty and is equal to "cell" and is not in the dictionnary list then
put the right ColorIndex
and put the value in the dictionnary list

VBA Macro Needs to find Last Instance of in Range

LinkBack

Thread Tools

Rate This Thread

Display

VBA Macro Needs to find Last Instance of in Range

Re: VBA Macro Needs to find Last Instance of in Range

Re: VBA Macro Needs to find Last Instance of in Range

Re: VBA Macro Needs to find Last Instance of in Range

Re: VBA Macro Needs to find Last Instance of in Range

Re: VBA Macro Needs to find Last Instance of in Range

Re: VBA Macro Needs to find Last Instance of in Range

Re: VBA Macro Needs to find Last Instance of in Range

Thread Information

Users Browsing this Thread

Similar Threads

find "w" instance in column L and count within range how can this code make to do that?

[SOLVED] start from bottom, find first instance of "Page", paste copied range below it...possible?

[SOLVED] To Find every instance of TEXT copy, repeat until no Find found

[SOLVED] Find first and last instance of text in column range multiple times

Macro VBA find last instance of a word

Find first and last instance

Find 2nd instance of a word in a range.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions