NoSparks thanks for the contribution. The only reason I prefer to use the worksheetfunction rather than the formula is because if the user is using VBA they can bypass any calculations that need to continually happen if a formula is put in.