Run time error 1004 application-defined or ofject-defined error

[katyg]

I have recently upgraded from Excel 2000 to 2007. I have always been able to record macros to use in any workbook without an issue.

No matter what I do, I can not seem to get a simple recorded macro to work.

The latest example is the following:

ActiveCell.Rows("1:27").EntireRow.Select
Selection.EntireRow.Hidden = True
ActiveCell.Columns("A:A").EntireColumn.Select
ActiveCell.Offset(27, 0).Range("A1").Activate
Selection.ColumnWidth = 7
ActiveCell.Offset(-27, 1).Range("A:A,C:C").Select
ActiveCell.Offset(0, 3).Range("A1").Activate
Selection.ColumnWidth = 5
**ActiveCell.Offset(-27, -1).Range("A:A,C:C").Select ----> debugger stops here
ActiveCell.Offset(0, 1).Range("A1").Activate
Selection.ColumnWidth = 10

nothing but changing column width.

I recorded the macro but I cannot run it. It gives me the error on the above line.

HELP!!! Is it asking to much for a recorded macro to actually run?