Posts by arpaanb

    Re: Offset and Match together in VBA


    Hello.. Thanks people... it worked like charm.. Pleasure.... :) Further, how to ensure that only the value/output is displayed in the active cell and not the entire formula?

    The existing formulae that I have entered in the worksheet Sheet1 is as under : OFFSET(FullName,MATCH(HHselect,policyholderid,0)-1,0,1,1), FullName is the name for the range in Sheet2, HHSelect is the Cell Number D22 in worksheet1, policyholderid is the name for the range in Sheet2. I am now trying to write this code in VBA and am un sure of how to go about this. Looking forward with your replies.