The first question is the most important:
Why can't I use the following vb function in excel modules:
mid,left,right,chr,space but i can still use instr. Is there anything
must click to enable theses?


The Second question is simple:
Why can't I rename the modules and they are named module1,module2 etc
No options will allow me as I right click on them to change it. Also i
I use this code it won't work and will tell me that the function i us
is not recognized by excel: activeworkbook.modules("module1").name
"modMain".
I really need theses informations thanks

--
Rubican
-----------------------------------------------------------------------
Rubicant's Profile: http://www.excelforum.com/member.php...fo&userid=1641
View this thread: http://www.excelforum.com/showthread.php?threadid=27789