Hi all,

I have a sheet which uses a macro to create a new workbook from templates.

In an effort to stop the new work book referring back to the old WS I started to use the Indirect function.

This just stops the formula from working in most instances, am I doing something wrong?

Or is there a better way to copy over exactly what is on the templates?

Thanks in advance