I have the workday function working perfectly in code, along with the eomonth function. When they have to be called a large number of times, it takes quite a while for excel to do it.
I have noticed that whenever the code calls the function, it makes an entry on the immediate window. This is currently the only thing that I can think of that might be causing it to slow my code down. Is there a command I can use to prevent it from making the entry in the immediate window? Or alternatively, can anyone think of another reason why it may be taking so long to run?
Thanks
James
I have noticed that whenever the code calls the function, it makes an entry on the immediate window. This is currently the only thing that I can think of that might be causing it to slow my code down. Is there a command I can use to prevent it from making the entry in the immediate window? Or alternatively, can anyone think of another reason why it may be taking so long to run?
Thanks
James