Hello,
I'm using VB6 and Excel 2007. I have a program that creates a report then
opens it in an Excel spreadsheet. I have doen a lot of formatting but
cannot figure out how to get it to do lines (ie: hairline). I tried the
following code but it doesn't work:
xlWS.Columns("A:K").Borders(xlEdgeLeft).Weight = xlHairline
xlWS.Columns("A:K").Borders(xlEdgeTop).Weight = xlHairline
xlWS.Columns("A:K").Borders(xlEdgeBottom).Weight = xlHairline
xlWS.Columns("A:K").Borders(xlEdgeRight).Weight = xlHairline
xlWS.Columns("A:K").Borders(xlInsideVertical).Weight = xlHairline
xlWS.Columns("A:K").Borders(xlInsideHorizontal).Weight = xlHairline
Any ideas?
Thank you,
Robert
Archived from group: microsoft>public>vb>ole>automation
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
