MrExcel
.
- Joined
- Feb 8, 2002
- Messages
- 3,417
- Office Version
- 365
- Platform
- Windows
I have a VBA macro that is taking a fair amount of time to run. After checking a timer with various parts of code, I was amazed that the following single line of code is taking 3 seconds:
Cells(1, 1).Resize(, 19).ColumnWidth = Array(12, 12, 6, 6, 6, 6, 8, 8, 6, 6, 8, 8, 8, 8, 6.5, 6, 6, 6, 6, 6)
When we get to this code, the ScreenUpdating is False and DisplayPageBreaks is False. I am puzzled why this one line takes so long to run.
Any ideas?
Bill
Cells(1, 1).Resize(, 19).ColumnWidth = Array(12, 12, 6, 6, 6, 6, 8, 8, 6, 6, 8, 8, 8, 8, 6.5, 6, 6, 6, 6, 6)
When we get to this code, the ScreenUpdating is False and DisplayPageBreaks is False. I am puzzled why this one line takes so long to run.
Any ideas?
Bill