View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geetha Geetha is offline
external usenet poster
 
Posts: 3
Default Operation is not allowed

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.