Hi,
See my reply (17th Feb) to your last posting ... does this help?

"Ctech" wrote:


Hi

I have a 50 replies from a questionaire.. they have all filled in with
the number 1 for their choice. (all the workbooks is in the same
folder)

I'm trying to use an empty template of this questionaire, and have a
macro sum up all the responses of the other workbooks in this
template.

Answere range is "C9:G19".

I've tried for two days now and Im about to give up... can some of you
give me some advice please.

Thanks


--
Ctech


------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=514342