Forum Discussion

Simon_Plant's avatar
Simon_Plant
17 years ago

Using DDT and checking if cell is blank

I want to be able to detect if some of the cells in my spreadsheet are blank. At the moment I get an error if it can't detect any data in the cell. I've tried: if DDT.CurrentDriver.Value...
YMinaev's avatar
YMinaev
Icon for Staff rankStaff
17 years ago
Hi Simon,



Try using the GetVarType method (see the "aqObject.GetVarType" help topic). Check whether it returns varEmpty.