JustATheory
IS-IT--Management
Greetings,
I'm trying to name a range of cells, and then compare two named ranges, if they're equal then I want to perform a function. If not then the cursor will go down to the next cell and name a new range and compare that with the prior one.
Example (below): I would name the first row "one" and the second row "two" and then test to see if "one" equals "two". In this case true so I perform the function, then I move down to row three name the range and test third row to second row, they are not equal, no function move to fourth row and so on.
I just need the best way to name a range and then test for true using VBA. Much thanks for the help.
Andy
A1 A2 A3
555-55-5555 5/24/2004 6/23/2004
555-55-5555 5/24/2004 6/23/2004
555-55-5555 5/26/2004 6/25/2004
555-55-5555 5/22/2004 6/21/2004
I'm trying to name a range of cells, and then compare two named ranges, if they're equal then I want to perform a function. If not then the cursor will go down to the next cell and name a new range and compare that with the prior one.
Example (below): I would name the first row "one" and the second row "two" and then test to see if "one" equals "two". In this case true so I perform the function, then I move down to row three name the range and test third row to second row, they are not equal, no function move to fourth row and so on.
I just need the best way to name a range and then test for true using VBA. Much thanks for the help.
Andy
A1 A2 A3
555-55-5555 5/24/2004 6/23/2004
555-55-5555 5/24/2004 6/23/2004
555-55-5555 5/26/2004 6/25/2004
555-55-5555 5/22/2004 6/21/2004