I still don't know how to execute the script on Column F though.

Just putting 6 in place of 1 in lookupcol=

gives me a runtime error


---
Message posted from http://www.ExcelForum.com/