Trying to make a formula blank.

RWayneH
RWayneH used Ask the Experts™
on
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 ""     ??
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
Custom format the formula cell with dd/mm/yyyy;; to hide 1900-01-00.

Author

Commented:
I cannot do that.. the required format is yyyy-mm-dd  because if it is not blank it needs to stay and use the date and in that specific reformat.
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
That's not the beg deal, you can custom format it with yyyy-mm-dd;;
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Author

Commented:
it is already....  I need it to be blank without the 1900-01-00 showing   ""

Author

Commented:
any other value is acceptable > today.  I am having issue making the cell = ""

Author

Commented:
ohhhh  hello the suffix of ;;  that worked.  I feel tiny.
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
Okay I made them bold so that you don't miss the complete syntax.
Glad it worked at last for you.

Author

Commented:
Thanks
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome. Glad to help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial