recover active worksheet and workbook from inside a UDF

Jun 26, 2013 at 2:22 AM
What is the canonical method for recovering the active sheet and then tinker with
{get|set} setting/coloring/fonts in a range in the caller sheet.
Jun 26, 2013 at 1:36 PM
One approach to recovering the active sheet is as follows:
return (ExcelDnaUtil.Application as Application).ActiveWorkbook.ActiveSheet;