Ok... This should be simple enough. Basically the Macro grabs the
entire contents of a sheet, creates a new sheet in the workbook, and
then tries to manipulate that new sheet.

Problem is, 50% of the time, a 1004 Error occurs when it begins to
makes changes to the new sheet.

Here's the relevant code:

Sub Main
Cells.Select
Selection.Copy
Sheets.Add
ActiveSheet.Paste
Columns("A:H").Select ' this line is where it screws up
<-----rest of code irrelevant / snipped-----
End Sub

The macro literally dies the 5th line into the code (sometimes).

Suggestions??? Any help will be greatly appreciated. As I stated,
sometimes it runs like a scalded dog. Other times it dies there.

Thanks,

-Jon Pickens