Posts by Mumps

    Try:

    What you want to do can probably be done with one macro rather than using the "Call" method. Do you want to perform the task only on the sections for the "Companies"? What about the "Individual Users" and "Full Level" sections?

    I have to clean different excel sheets

    In your sample file, you have only one sheet. If you want to clean multiple sheets, please attach a revised file which contains at least 2 or 3 sheets. Also, include a sheet that shows the desired result.

    Try:

    Try:

    This macro assumes you have a sheet named "Shee2" with these headers in row 1.

    id name value


    Try:

    Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your Sheet2 and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make a selection in A3, then make a selection in B3 and lastly, make a selection in C3. It is very important that the selection in C3 is made last because that selection triggers the macro.

    Before testing it on all the sheets, try this code in the code module for the "Temp" sheet and see how it works.