Run-time error '1004':

Application-defined or object-defined error.


-----------------------------------------------------

I have one main macro that creates new workbooks, puts data in them based on at text file, then formats them how they need to be (Cell data format, coloring, spacing, etc). For some reason Columns("A:A").Select gives me an error. Is this because I am creating a workbook from code? If so, how do I make it work?