Excel UDF's (in any language) cannot change the worksheet they're in, only
return a value (or array of values).

Tim


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