Find Specific Value from Cell and Merged with Adjacent Cell

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question


    Hi All,

    I have a excel sheet where column A have sub total for each category. (No. of rows in attached sample file is not fixed)

    I want to find sub total and merge that cell with adjacent cell then align entire row to center and align merged cell to left alignment with proper border formatting as showed in sample file.

    I need solution in vba code.




  • Try this