Ken
12/14/2006 5:52:00 PM
keri
It seems unlikely that changing the alignment would give you ####, but,
if the alignment is done in conjunction with the ...font.bold=true
line, it could be that the column is no longer wide enough.
Ken
keri wrote:
> I have searched other posts and tried to implement the answers but I
> still do not have code that works.
>
> I have code so far that says;
>
> ActiveSheet.Range("a1:p1").Font.Bold = True
> ActiveSheet.Range("a1:l500").Borders.LineStyle = xlNone
>
> etc
>
> I want to add a line that aligns the text in the named range to the
> left. I found a post that suggested this
>
> ActiveSheet.Range("a1:n500").HorizontalAlignment = xlLeft
>
> However when I run this code it changes all of my values in the
> selected range to #######
>
>
> Thanks.