Code I Have In A Module Slowing Down Data Entry

[PIPPIBOOKS]

Hello, I have the following code written into a module right now

Please Login or Register  to view this content.

It is making my spreadsheet calculate constantly when I am entering data. I need this code however to calculate my sheet when I am done entering data after several days. Is it possible to make it into a macro I can tell to run when I am ready? Thanks for your help

[Richard Buttrey]

Hi,
You could leave the formula cells blank until you're ready, then use a macro to create the UDF function in the sheet and copy it down the appropriate rows.

Rgds