VBA Border

[slivesay]

I have the below coding and it works great, but I'd like add on to it. Right now it puts a border around all cells that contain value. My number of columns will always be the same (A-Y), but my rows will be different. How can I add the border to the blank cells right after my last column that contains data?


'BORDERS
With ActiveSheet.UsedRange.Borders
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With

 

[slivesay]

Again, thank you so much. I have created a new thread.