Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am a VSTO 2005 user. We are getting the following error, although not
consistently, while trying to add a new list object in Worksheet.ListObjects collection: listObject = myWorksheet.Worksheet.ListObjects.Add(Excel.XlList ObjectSourceType.xlSrcRange, position.TopLeftCell, Type.Missing, Excel.XlYesNoGuess.xlYes, Type.Missing); "The operation is not allowed. This operation is attempting to shift cells in a list in your worksheet." Please note that this list object previously existed in the ListObjects collection, and was then deleted, and is now being re-added again. Since it is not happening consistently, I am not able to understand what might be causing this. -- Thanks Geetha. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
allowed/taken | Excel Worksheet Functions | |||
allowed / taken | Excel Worksheet Functions | |||
Change cut/paste operation to cut/insert operation | Excel Programming | |||
"operation is not allowed when the object is closed" error when us | Excel Programming | |||
Operation Is Not Allowed When The Object Is Closed | Excel Programming |