I need to change the codes and let it reverses the colors back.

[akinkaraman]

With this macro, after I select 1, I can search and find a value and color it.
Because of we can not use Ctrl Z after using a macro, I wanted to put Selection 2 to reverse colors back but when I select 2, it removes all the cell's original colors. What I wanted is I use Selection 1 to search, find and color it then I want to run the macro again and select 2 to reverse the colored cells back.

Can you help me to fix the codes of Selection 2?

[LJMetzger]

Hi akinkaraman,

Thanks for the rep points.

Try the following code which is included in the attached updated copy of your file:

Please Login or Register  to view this content.

0a. To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. Dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspx

Lewis

[akinkaraman]

I am really very very appreciated. It is awesome and working wondeful.

I want to ask one thingh while I check the codes. When I search TR* it finds TRIP but when I search tr* it can not find TRIP . Is there a solution for big letters and small letters?

[LJMetzger]

For the search to be Case Insensitive (match any combination of upper and lower case text) add the 'Option Compare Text' line immediately below 'Option Explicit'.

Please Login or Register  to view this content.

Lewis

[akinkaraman]

Awesome. You are a master LJMetzger. Thank you so much.