Hi

I have a small excel estimate form which needs to be able to expand t
accomodate extra information when required. When finished I simpl
print the form off and want to return the form back to its origina
size with all the entered data removed. I recorded a macro whic
deleted the form and pasted in its place a copy of the original store
on a different worksheet. Worked great untill I tried to shar
it.........now I get "run time error 1004" The way the worksheet i
setup means I would rather not just delete the whole sheet and replac
it with one stored as a template which is what the microsoft knowledg
base suggests. If anybody has any ideas I would be grateful..........t
date my ability to compile macros is limited to the "record" functio
but im happy to have a go if someone can point me in the righ
direction.

Many thank

--
Nige
-----------------------------------------------------------------------
Nigel's Profile: http://www.excelforum.com/member.php...fo&userid=2569
View this thread: http://www.excelforum.com/showthread.php?threadid=39112