Sorry if this is a repost, but having some trouble searching for the answer and pretty tired right now.
I'm just wondering how to make a border around a range of cells in Excel. I want the regular lines created by selecting "All Borders" option around F2:G3
I saw this code:
With $oExcel.ActiveSheet.range("F2:G3")
.Select
.Borders($xlEdgeBottom).LineStyle = $xlContinuous
.Borders($xlEdgeBottom).Weight = $xlThick
.Borders($xlEdgeBottom).ColorIndex = $xlAutomatic
EndWith
but I get errors of these variables not existing. It seems these no longer exist in the "#include <Excel.au3>"
Is there another include file I need?
I got this to work for highlighting cells, wondering if there is a option similar to this for all borders?
$oExcel.ActiveSheet.Range("F2:G3").Interior.ColorIndex = 6
Thanks