View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gennie Gennie is offline
external usenet poster
 
Posts: 8
Default Syntax of Commands Created by Macro Recording

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