I'm creating an Excel app that gets a lot of data from another application (PI-System). I am doing some calculations and in some cases there are empty cells in the range that I'm doing a calculation on. Eventually, the empty cells might have data in them. I don't want the user to see the #VALUE! in the formulated cell. Help please!