Prev: Calculate week from current day
Next: ModifyAppliesToRange
From: Gennie on 8 Dec 2009 11:18
Hi All,

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

http://www.keyongtech.com/5265319-extraneous-data-in-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
 | 
Pages: 1
Prev: Calculate week from current day
Next: ModifyAppliesToRange