You already received the answer to look in tools = references. This is the
source of your problem more than likely. It has nothing to do with your
code.
--
regards,
Tom Ogilvy
"aries58" wrote in message
...
Here a symple code sample which does not work!!
k = "SSSSSSSSSSS"
s = MID(k , 3 , 3)
msgbox s
I should get a message containing "sss"
I have a message from the dedugger which does not recognize the MID
function!! Anyway I cut and past a lot of part of code wich works in
my computer , i.e. is not any mismatching problem.
TIA
Aries58
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/