I have an Access 2010 Database That exports Data to several Worksheets in an Excel 2010 Spreadsheet
One of the requirements is that each cell needs to have a border on all 4 sides. I've tried everything I can find and nothing works. Anybody know how I can set the borders of the cell in Access VBA?
Some of the things I've tried
1. cell.BorderAround LineStyle = xlContinuous, Weight:=xlThin
2. cell.Borders (xlAll)
3. With Cell.Borders
.Linestyle = xlcontinuous
.Weight = xlMedium
.Color = RGB(255,255,255)
End With