| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro takes 30+ seconds to do an autofit on only 1 out of the 3 sheets it is autofitting
think i found it... Range("A1", ActiveCell.SpecialCells(xlLastCell)).Select looks like it working a lot faster now... thanks for your help -- drdavidg ----------------------------------------------------------------------- drdavidge's Profile: http://www.excelforum.com/member.php...fo&userid=3616 View this thread: http://www.excelforum.com/showthread.php?threadid=56110 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Takes 30 Seconds Plus to Save First Time | Excel Discussion (Misc queries) | |||
| Saving takes 30 Seconds | Excel Discussion (Misc queries) | |||
| Copying single cell takes 15-20 seconds | Excel Discussion (Misc queries) | |||
| macro takes 30+ seconds to do an autofit on only 1 of 3 sheets it is autofitting | Excel Worksheet Functions | |||
| Save takes seconds vs. SaveAs/Save As takes minutes | Excel Programming | |||
![drdavidge[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
