| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel hangs on 'shtA.Cells(person_row, 1).EntireRow.Insert' comman
I have a fairly complicated spreadsheet, with a good deal of VB code behind
the macro buttons. In the middle of processing a large file, Excel 2002 seems to get caught up on itself doing the fairly simple command: shtA.Cells(person_row, 1).EntireRow.Insert Shift:=xlDown, copyorigin:=xlFormatFromRightOrBelow Are there any bug fixes that stop Excel 2002 from hanging during an insert command? Are there any equivalent commands that are less prone to causing Excel 2002(10.6713.6804) SP3 to hang? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Access denied when running Excel from DOS prompt with runas comman | Excel Discussion (Misc queries) | |||
| Access denied when running Excel from DOS prompt with runas comman | Excel Discussion (Misc queries) | |||
| Excel hangs when remove some cells | Excel Discussion (Misc queries) | |||
| Macros cells.EntireRow.Hidden = True and Range.Sort are stopping | Excel Programming | |||
| Entirerow.delete based on multiple cells | Excel Programming | |||
![Gordon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
