Thanks Dan E. for your kind help. Your solution worked fine.

I have a worksheet that fills columns of cells with whole numbers using
the VLOOKUP command. Your solution works fine unless one of the cell
contains the #N/A error code which occurs when the VLOOKUP can not find
valid information. How can I get your solution to work while ignoring
these error codes? Thanks for your help.
Chuck



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