Re: $$Excel-Macros$$ CODE FOR RANGE

Thanks for your help -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ CODE FOR RANGE

In your macro:Sub sbCompareColumns_2()     iCntr = 1     Do While Cells(iCntr, 1) <> ""     If UCase(Cells(iCntr, 1)) = UCase(Cells(iCntr, 2)) Then     Cells(iCntr, 3) = "Matched"     Else     Cells(iCntr, 3) = "Not Matched"     End If     iCntr = iCntr + 1     Loop

$$Excel-Macros$$ CODE FOR RANGE

If I change the location of the data as shown in A12:B16, then where should I change the code, please do the needful -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @