Naomi,

On what line? Or it does not matter? Probably we could go straight to the point if you send to me Excel file sample to reproduce the behavior.

>I'm getting "Unable to set the LineStyle property of the Border class" error.
>
>What is wrong in this code?
>

>
>** Now apply borders to each header cell
>	lcRange = "A" + alltrim(str(m.lnLines + 2)) + ":" + ;
>		m.lcEnd + alltrim(str(m.lnLines + 2))
>
>	with loSheet.range(m.lcRange)
>		with .borders(xlEdgeLeft)
>			.LineStyle = xlContinuous
>			.Weight = xlThin
>			.ColorIndex = xlAutomatic
>		endwith
>		with .borders(xlEdgeTop)
>			.LineStyle = xlContinuous
>			.Weight = xlThin
>			.ColorIndex = xlAutomatic
>		endwith
>		with .borders(xlEdgeBottom)
>			.LineStyle = xlContinuous
>			.Weight = xlThin
>			.ColorIndex = xlAutomatic
>		endwith
>		with .borders(xlEdgeRight)
>			.LineStyle = xlContinuous
>			.Weight = xlThin
>			.ColorIndex = xlAutomatic
>		endwith
>		with .borders(xlInsideVertical)
>			.LineStyle = xlContinuous
>			.Weight = xlThin
>			.ColorIndex = xlAutomatic
>		endwith
>		with .borders(xlInsideHorizontal)
>			.LineStyle = xlContinuous
>			.Weight = xlThin
>			.ColorIndex = xlAutomatic
>		endwith
>	endwith

>
>>Naomi,
>>
>>Not only those; there are also Diagonals....
>>However, some settings are defaults, and then you may omit to code them