This solved problem.

Regards to all for help.
--
Regards and Thanks for any assistance.

Francis Brown.


"Chip Pearson" wrote:

I got another problem with declaring the variable name in the
workbook
module.

Unless you have good reason to do so, don't declare the variables
in the ThisWorkbook module. Declare all your global variables in
a standard code module.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Francis Brown" wrote in
message
...
Thanks For answer.

That problem is cleared.

I got another problem with declaring the variable name in the
workbook
module. When the program to set the variables was called it
through up a
problem about setting a variable form which the module was
derived. I changed
the variable name to namex and this resolved. Although I could
not find the
other declaration the error was talking about.

However I have the following problem

My program to set the variables works but when I run a small
test program
imedietly after the first with MSGBOX commands for all the
variables they
come up empty.

any ideas.
--
Regards and Thanks for any assistance.

Francis Brown.


"Leith Ross" wrote:


Hello Francis,

Remove the Set statements from you variables name, team,
TeamLeader,
and CommandN.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread:
http://www.excelforum.com/showthread...hreadid=488468