Posts by kulshresthazone

    Re: Formula to compare 2 new lists and return a Value

    As per your worksheet data. I tried using this formula .


    Please do not quote entire posts. When quoting follow these guidelines

    1. Quote ONLY if it is needed to add clarity or context for your reply. If so, then
    2. Quote ONLY the specific part of the post that is relevant - - not the entire post.

    This will keep thread clutter to a minimum and make the discussion easier to follow. Quote deleted.

    Re: Find Last Row in Array with Multiple Criteria

    You Can try this formula , where A2:A12 represent C1, B2:B12 represent C2, C2:C12 represent C3.

    Re: Return active OLEObject in Worksheet

    You Can make use of Application.Onkeys.
    Application.OnKey "{TAB}","KeyCapturing"
    Application.OnKey "{ESC}","Rangeselect"

    In the first on keys whenever a user press tab button the KeyCaputring macor will be called. and in case of second onkeys event rangeselect will be called.