Merging Cells and Adding Boarders Using VBA

[The Noob]

Alright, I just created an account and I am hoping to find some help here. I have worked in excel quite a bit and I am very comfortable with using formulas and such. I have never dug into Macros or VBA due to the fact that I have no coding experience. I have created a sheet where I bring in exported data from another program. My sheet takes that data and organizes it into a material list. I am running into the situation now where I am trying to get the headers of each section to merge and add formatting. I do not think this can be done without a macro. I started digging into it today, and this is what I have so far.

If you look at capture 1, it shows my original list without any macros. I have written a short script to get the cells to merge (see capture 2 for script) (capture 3 for results). I am now trying to apply formatting to those merged cells.
I would like the merged cells to have a thick continuous border, and bold size 14 text.

I am sure this is a cake walk for most of you! I am new to this side of excel and kind of excited to finally start digging into it.

 

[yky]

I think the best way is to do a macro recording and then modify the macro generated by Excel.

 

[vmjan02]

@The Noob

Great to know you have cracked some of the coding
This code will be a help to you and you can modify as per your wish list. Enjoy

sub Bodermerge()
Dim c As Range
For Each c In testing 
   If c.MergeCells Then
       With c.MergeArea
            .Interior.ColorIndex = 19
            .Borders.LineStyle = xlContinuous
            .Borders.Weight = xlThick
            .Borders.Color = vbGreen
       End With
   End If
 Next
 End Sub

as per your wish

 

[The Noob]

@vmjan02

Works perfectly, thanks! I have been messing around with VBA for a few days now and I finally seem to be getting a grasp on it! (no longer trying to compile and getting errors over and over again)
Feels good to finally start learning a little coding and macros after putting it off for so long.

 

[vmjan02]

Great and Welcome