So I'm writing this program and I want to output some of the variables to an Excel spreadsheet. Fine, I can do that. So then I want to Set some cell properties to make things look nice. I can set column widths, I can make cell text bold, BUT I CAN'T SET THE HORIZONTAL ALIGNMENT!!! It's driving me nuts!!


Here is a snipit from my code
___________________________________________
Do Until CCLrst.EOF
        If strreg = CCLrst!Reg Then
            With xlCCL.activesheet
                .Cells(currentrow, currentcolumn).Value = strletter
                .Cells(currentrow, currentcolumn).wraptext = True
                .Cells(currentrow, currentcolumn).HorizontalAlignment = xlcenter
------------------------------------------------
the last line give me a "run time error '1004'" Unable to set the HorizontalAlignment property of the Range Class.

This is truley driving me nuts. Anyone have any ideas?
I am running Windows XP and Access 2000