I have create a custom function in c# using vsto excel.

I had a issue while running this Custom function in new excel sheet .

The issue was i need to select the default cell range of columns and
rows for displaying the results. With out that unable to display.
My question was without selecting the default range of cells, unable
to display records in Excell sheet.

So Please provide me a solution forthis.