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?

Gordon,
I can't test it (no xlFormatFromRightOrBelow), but does it make a difference
if you remove the "copyorigin" argument ?
Do you have error trapping in the routine ?

NickHK

"Gordon" wrote in message
...
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?