VBAExpertWannabe
New Member
- Joined
- Jan 8, 2020
- Messages
- 10
- Office Version
- 2019
- Platform
- Windows
I want to apply borders to the right edge for Column H of my data, starting from J:20 onto the last row of data (there are several rows of empty data in between). I have the following code but somehow, it is not working. Can anybody see what I did wrong? Thanks.
Sub Border()
Range("J" & Rows.Count).End(xlUp).Borders(xlEdgeRight).LineStyle = xlContinuous
End Sub
Sub Border()
Range("J" & Rows.Count).End(xlUp).Borders(xlEdgeRight).LineStyle = xlContinuous
End Sub