Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all , and a good day
I have 2 ranges , with these values : myRange1 = (ROW) A B C 1 1 2 4 2 1 3 4 3 1 3 5 myRange2 = (ROW) F G H 1 1 3 4 2 2 3 5 3 1 4 5 I need a macro to compare every cell in myRange2 - first row !! , with every cell in myRange1 - first row !! , and , if tha value of every cell in myRange2 is equal with one of the cells of the first row of myRange1 , to change the value with "QQQ" . This must to be done in every row . After checking first row of myRange2 with first row of myRange1 , to go to next row in myRange2 , and compare with the values of the next row of myRange1 . To compare row to row . So , the results will became : myRange1 = (ROW) A B C 1 1 2 4 2 1 3 4 3 1 3 5 myRange2 = (ROW) F G H 1 QQQ 3 QQQ 2 2 QQQ 5 3 QQQ 4 QQQ Thank you in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.Match - Is it possible to use named ranges? | Excel Programming | |||
Application.Match and Ranges | Excel Programming | |||
Like match between 2 ranges | Excel Discussion (Misc queries) | |||
Problem w/ Match prop vs. Match method | Excel Programming |