ran large macro, workbook now slow

[egris52788]

I have a workbook that is relatively small in size, i colored a number of rows, then ran a macro that deleted the color from a1000 to az1000000. Now the workbook takes 10 minutes to open and to save. I have since deleted that macro, shut excel down, turn computer off, etc. and it is still slow now. any ideas?

 

[Datsmart]

Any time you Format an entire Row or Column, you are formatting a lot more cells than you need. Deleting the color does not remove the fact that the cell is Formated, it just changes the color. You need to delete the cell to tell Excel it is no longer being used.
Try hitting Ctrl-End and see where your cursor ends up. That is the end of your used data.
Any Formatting outside that range is loading your computer with an un-needed burden.

 

[theozz]

workbook now slow

sometimes Err's like that...
that time...
1. blank sheet insert
2. used cell copy (if used a1:s20 , a1:s20 select and copy)
- use Paste Special -
3. paste formulas (a1:s20)
4. paste cell formats (a1:s20)
5. use macro adjust columnwidth and rowheight

adjust as below

Sub x()
Dim i
For i = 1 To 5
ActiveSheet.Cells(1, i).ColumnWidth = Sheets("sheet2").Cells(1, i).ColumnWidth
Next

For i = 1 To 5
ActiveSheet.Cells(i, 1).RowHeight = Sheets("sheet2").Cells(i, 1).RowHeight
Next
End Sub