Set borders dynamically around a range - vba

[kelly mort]

Hello geniuses,
I am looking for a vba script that can set borders like the image here.
The data can grow or shrink. And when it does, I want to adapt to it with the borders.

I hope someone can fix it for me.

Thanks in advance.

 

[kelly mort]

@Peter_SSs
Super awesome!
But this line

 .NumberFormat = "0.00"

Is affecting the dates. How do we eliminate the dates from its effects?

 

[Peter_SSs]

Is affecting the dates.

Ah, yes, sorry about that. Problem was you didn't give any sample data that we could copy so I just made up rubbish and didn't even have dates.
Leave that NumberFormat line as it is and add this one immediately below it

.Cells(4, 3).Resize(Rws - 4).NumberFormat = "dd-mm-yy"

 

[kelly mort]

All set for now.

Have a wonderful time

 

[Peter_SSs]

All set for now.