found the problem

dim prange as string

should be

dim prange as variant

Thanks for all the help

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!