'VBA to check if cell A1 has a value. 'Two different ways... MsgBox Not IsEmpty([A1]) MsgBox Not Len([A1]) = 0
IF(A1<>"","Not empty","Empty")
var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var range = sheet.getRange("B2:D4"); Logger.log(range.isBlank());