Compiled Excel add-in Write to Worksheet

I have a function to be compiled and used as an Excel add-in. From within this function I need to write to a worksheet in the ActiveWorkbook. Below is a simple function I'm using to test with:

function writeResults(Periods, Loans1, PmtFreq, TermYrs, InvPeriodYrs, ReInvPeriodYrs, MaxInvestCap, Recycle_Permitted, Recycle_Percentage, A, B, trials)

N = trials;

h = waitbar(0, 'Please wait...');

% run the simulation

for n = 1:N

%This is a call to another matlab function

Investment_mat(Periods, Loans1, ...

PmtFreq, TermYrs, InvPeriodYrs, ReInvPeriodYrs, MaxInvestCap, Recycle_Permitted, ...

Recycle_Percentage, A, B);

% waitbar

waitbar(n/N, h, ['Number of the test: ' num2str(n)])

%After each interation I want to write a result to a given range on a specific worksheet

end

% close the waitbar

close(h)