You can't get that error as it is a Function, not a Sub.
Look elsewhere in you code for a missing "End Sub".

NickHK

"Eladamri" wrote in
message ...

Hi NickHK,

I still receive an error
Compile Error:
Expected End Sub

But thank you very much for your help. I Greatly appreciate your help.


--
Eladamri
------------------------------------------------------------------------
Eladamri's Profile:
http://www.excelforum.com/member.php...o&userid=35099
View this thread: http://www.excelforum.com/showthread...hreadid=559205