Re: $$Excel-Macros$$ Mark Pass/Fail using excel vba macro

Can you explain it bit more with one example sample of 9 to 10 lines only... Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Nov 12, 2014 at 4:52 PM, Laxmanan M laxflyflow...@gmail.com wrote: Thanks vabz, How to achieve the second macro using

Re: $$Excel-Macros$$ Mark Pass/Fail using excel vba macro

Hi Vabz, i have done part of it and i need some amendments alone. 1) Macro for BG: It works fine. But there should be an additional condition. I won’t be able to explain it, but I will try to represent it on this picture. On this picture below all the lines should be OK, because there is

Re: $$Excel-Macros$$ Mark Pass/Fail using excel vba macro

Thanks vabz, How to achieve the second macro using vba.I tried here but am failing when trying to fetch details.. Lax -- 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 @

Re: $$Excel-Macros$$ Mark Pass/Fail using excel vba macro

check this code for macro 1 Option Explicit Sub Check_Dupe_2() Dim n, i, str() As String Application.ScreenUpdating = False n = Range(A Rows.Count).End(xlUp).Row ReDim str(1 To n + 1) With CreateObject(Scripting.Dictionary) For i = 1 To n str(i) = Cells(i, C) Chr(30) Cells(i, AF)