How do I make the bottom row merge + with colour?

[nonono]

I want to make the cell in (Before) A191:F191 merge like the (After) A207:F207 and making H191 look like H207

Color properties in H207 is

 

[nonono]

Report range is dynamic and will increase as more reports are use daily...

 

[nonono]

still need all the help

 

[nonono]

still need help ... T.T

 

[nonono]

.

 

[Michael M]

Do you want a VBA solution ?
Also, avoid merging cells at any cost !....it will cause so many issues especially if using VBA !

 

[Michael M]

Try something like this

Sub MM1()
Dim lr As Long
lr = Cells(Rows.Count, "A").End(xlUp).Row
Range("A" & lr + 1).Value = "Average"
Range("A" & lr + 1 & ":G" & lr + 1).HorizontalAlignment = xlCenterAcrossSelection
Range("H" & lr + 1).Value = Range("H" & lr).Value
With Range("A" & lr + 1 & ":H" & lr + 1).Font
        .FontStyle = "Bold"
        .Size = 11
End With
With Range("A" & lr + 1 & ":H" & lr + 1).Interior
        .ThemeColor = xlThemeColorAccent6
        .TintAndShade = 0.599963377788629
        .PatternTintAndShade = 0
End With
End Sub

 

[nonono]

oh boi it work like a charm . Thank you sir for your time... am appreviate your help alotttttttttttttttttttttttttttttttttttttttttttttt

 

[Michael M]