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").Entire Row.Select
Selection.Entir eRow.Hidden = True
ActiveCell.Colu mns("A:A").Enti reColumn.Select
ActiveCell.Offs et(27, 0).Range("A1"). Activate
Selection.Colum nWidth = 7
ActiveCell.Offs et(-27, 1).Range("A:A,C :C").Select
ActiveCell.Offs et(0, 3).Range("A1"). Activate
Selection.Colum nWidth = 5
**ActiveCell.Of fset(-27, -1).Range("A:A,C :C").Select ----> debugger stops here
ActiveCell.Offs et(0, 1).Range("A1"). Activate
Selection.Colum nWidth = 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?