I checked the file path, and it's correct, unless there are not supposed
to be brackets around the last bit...tried taking them out without
success. Input the code into the macro, got an error 13 "Type
Mismatch" with the line:

If Len(varValue) < 1 And varValue < 0 Then


--
andysgirl8800
------------------------------------------------------------------------
andysgirl8800's Profile: http://www.excelforum.com/member.php...o&userid=34752
View this thread: http://www.excelforum.com/showthread...hreadid=547498