Are you trying to get around the error? You can't if the long is less than -32,768 or greater than 32,767. By the way, look up CInt in help and you will find a discussion of various conversions.

------------------
Marty

[This message has been edited by MartinLiss (edited 12-10-1999).]