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
Bookmarks