xlmedium

Hi I thought Borders, is a properties of Range object and its data type is Borders. So the in MS page it says the follwing (without s) Worksheets("Sheet1").Ovals(1).Border.Weight = xlMedium https://docs.microsoft.com/en-us/office/vba/api/excel.border.weight Thank you.

Hello, It's AGES since used any macros and even then I only really recorded them and tweaked them. I'm trying to create a macro that formats some data. However when I run it I end up with a completely blank sheet except for a bit of writing and thick box borders - all the data that was in the...

I use Range("A7", "N" & lastrow).Select Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .ColorIndex = 0 .TintAndShade = 0 .Weight =...

Hello Everyone, I would imagine this to be a very easy fix for the skilled members of this forum, but I personally do not know how to do so. I created the following simple macro that applies border lines to select cells. It adds a border around the edges, as well as adds border lines to...