Hi All,

In case you are also having this issue, the solution is he

http://www.keyongtech.com/5265319-ex...macro-recorder

Gennie


"Gennie" wrote:

Hi Experts,

I need your help. I have recorded a macro to format cells with borders.
Please see below the corresponding commands created by macro recording:

Selection+Borders&xlDiagonalDown'+LineStyle <= xlNone
Selection+Borders&xlDiagonalUp'+LineStyle <= xlNone
Wend Selection+Borders&xlEdgeLeft'
+LineStyle <= xlContinuous
+Weight <= xlThin
+ColorIndex <= xlAutomatic
ElseIf Wend

You will notice that those that should have periods (.) have plus signs
instead and those that should just have space have "less than" (<) character.


Please help what is causing this problem. Thank you.

Gennie