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
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.