| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grabbing data from diff window w/o activating it
Good evening McManCSU From what your post says, it is probably the screenupdating proces that is slowing your macro down. Try using this trick to speed it up. make the first line of your macro: Application.ScreenUpdating=False and the last line of your macro: Application.ScreenUpdating=True This should speed your routine up considerably. HTH Dominic -- dominic ----------------------------------------------------------------------- dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893 View this thread: http://www.excelforum.com/showthread.php?threadid=39693 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| grabbing data from MS Word | Excel Programming | |||
| Error on activating a window a open workbook | Excel Programming | |||
| De-Activating the menu option, Window - Unfreeze | Excel Programming | |||
| How to hide Excel window when activating a Shape object | Excel Programming | |||
| How to hide Excel window when activating a Shape object | Excel Programming | |||
![dominicb[_92_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
