Trying to make a formula blank.
Posted on 2016-09-13
If the following Ln on a sheet, grabs a value and that value is a Date.
ActiveWorkbook.Names.Add Name:="ColI", RefersToR1C1:="=" & Me.Name & "!R" & Target.Row & "C9" ' LnReqDelDate
however if the cell it is grabbing in column 9 from, is blank it returns: 1900-01-00
I use the formula on =ColI on another sheet to put that value in.
Is there another way to write the formula =ColI so that if it returns 1900-01-00 (meaning blank) , it can make it "" ??