I need to select LastRow, Columns L through N to draw a double line
before my Total row.
But, because my LastRow varies, my Range Select cannot be hard coded.
What is the proper Range Select Syntax to say something like
Range("L:N" & LastRow).select ?
..
LastRow = Range("L65000").End(xlUp).Row
Range("L23:N23").Select ' Range syntax to be corrected for variable
LastRow.
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlDouble
.Color = -3407872
.TintAndShade = 0
.Weight = xlThick
End With
..
Help appreciated,
J.P.