[code]

Sheets("Analyzer").Copy
Application.Goto Reference:="R1120C54"
Range("BB1120:BV1139").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Range("BC1140:BI1168").Select
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
ActiveWindow.SmallScroll Down:=31
Range("BC1178:BI1181").Select
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
ActiveWindow.SmallScroll Down:=-50
Range("BB1:BB1118").Select
Range("BB1118").Activate
Application.CutCopyMode = False
Selection.EntireRow.Delete
Range("A1:BB1").Select
Range("BB1").Activate
Application.CutCopyMode = False
Selection.EntireColumn.Delete
Range("A1").Select
--
Mary Frances


"Don Guillett" wrote:

Yes, Post your code.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mary Frances" wrote in message
...
I have a 9 mb file that I want to create a macro that will copy/paste/new
workbook/creat a copy for one of the sheets, then copy/paste values some
of
the cells in the new workbook, then delete A1:BB1119. The macro I have
written should work, but does not. If I delete the rows and then the
columns, the rows will delete, but not the columns. If I delete the
columns
first, the rows will not delete. I am thinking Excel may have a limit on
how
many deletions it can do in a macro. Do you have any ideas on how I can
accomplish this task?
--
Mary Frances