I've got a very long spreadsheet that I copy information to every day. I
would like to format the text that is copied over via a range command to be
formatted like the existing text in the document which would mean I need to
change the following charactristics
.HorizontalAlignment = xlLeft
Selection.Font.ColorIndex = 0
Selection.Font.Bold = False

Is there a way, since this speadsheet has over 50,000 rows to just designate
the last 30 cells in col B have the above format?

Thanks