I'm having a lot of trouble manipulating XL objects from my AddIn code (A C#
Automation AddIin that serves as a UDF).

I Can:
Read Cell Valules
Insert Comments Into Cells
Call Replace() Functions on Cells\Ranges
Obtain Handles to Ranges
Various other things

I CANNOT:
Insert Data directly into a cell (without using Replace function)
Insert Rows
Paste Data Into a Range

The sheet is NOT protected


Here is a line that does nothing (no error message at all)
range.EntireRow.Insert(Microsoft.Office.Interop.Ex cel.XlInsertShiftDirection.xlShiftDown, m);


another ugly example:
rCml.Select();
rCml.Copy(m);
range.Select();

range.PasteSpecial(Microsoft.Office.Interop.Excel. XlPasteType.xlPasteAll,Microsoft.Office.Interop.Ex cel.XlPasteSpecialOperation.xlPasteSpecialOperatio nNone, false, false);


again, no error message, but no result either....

this is becoming critical.

thanks for any help you can offer.



--
Cheers,

Gregory A Jackson
Portland, OR