HorizontalAlignment Error in Excel 97

[Werner]

Hi,

I have a HorizontalAlignment line code that doesn't want to work. It says : "Error '1004' : Unable to set the HorizontalAlignment property of the Range class.". I am in Excel 97 and it is frustrating not being able to do such a simple task with VBA. It shouldn't be difficult. Cells are not even merged. Any ideas?

Werner

    Worksheets("Formulaire").Range("A6:AE11").Select
    With Selection
        .HorizontalAlignment = xlLeft
    End With

[K Dales]

Try this:
..HorizontalAlignment = xlHAlignLeft

--
- K Dales


"Werner" wrote:

>
> Hi,
>
> I have a HorizontalAlignment line code that doesn't want to work. It
> says : "Error '1004' : Unable to set the HorizontalAlignment property
> of the Range class.". I am in Excel 97 and it is frustrating not being
> able to do such a simple task with VBA. It shouldn't be difficult.
> Cells are not even merged. Any ideas?
>
> Werner
>
>
> Code:
> --------------------
>
>
> Worksheets("Formulaire").Range("A6:AE11").Select
> With Selection
> .HorizontalAlignment = xlLeft
> End With
>
> --------------------
>
>
> --
> Werner
> ------------------------------------------------------------------------
> Werner's Profile: http://www.excelforum.com/member.php...o&userid=24304
> View this thread: http://www.excelforum.com/showthread...hreadid=392946
>
>

[Werner]

It works! Thanks a lot!

Regards,

Werner