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.