Merge cells from Active cell and just before row called Total

[Richavlaues]

Hi Experts,

Am new to VBA and tried to record macro to copy table from pivot table and it worked fine but now I want to do some formatting on the copied table.

Am always copying data from pivot table and copying to cell starting at Range("D23"). I want to merge cells from D25 till row before "Total". I tried recording and its hardcoded. If number of rows increase/decrease it merge cells with hardcoded range. Is it possible to select range till "Total" and merge?

Here is the table how it looks before formatting/merging:
T1.JPG

This is how I want table to look like:
T2.JPG

Also how can I rename "Grand Total" to "Total"

Any help much appreciated.

Thanks,
Richa

[Richavlaues]

I tried myself and its fixed.

Please Login or Register  to view this content.

Please feel free to optimize code if required.

Thanks,
Richa