Apply border around cells using vba

[ipbr21054]

Hi.
Ive managed to removed borders around a range of cells using this.

Range("G38:G40").Borders.LineStyle = xlNone

Now can you advise the line of code to apply border around a range,in the drop down menu on the address bar its called All Borders

 

[MARK858]

Try changing xlNone to xlThin

 

[ipbr21054]

This did it thanks.

Range("G38:G40").BorderAround , Weight:=xlMedium

 

[MARK858]

Borderaround is not the same as all borders

 

[ipbr21054]

The code i used put a border around the range in my code.It looks like what i required.
The goal was to have a dark border around the outside of G39:G40 which what i advised did.
Thanks anyway for your reply

 

[MARK858]

Then please don't state it is called Borders All. If you are not sure what something.is called then omit it please

 

[smozgur]

The marked solution has been changed as post #2 answers the original question.