I was wondering how to hardcode the workbook to work for exel 2002 and exell 2010 whhat is the best way to use hardcoding the sumproduct funtion in i would like to make it so i can hard code the sdumproduct in so i don't have to sulect it in exel it self.