Yahoo Answers is shutting down on 4 May 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
atomzer0
Lv 6
Excel VBA Help?
I have a spreadsheet with dates in columns EB and EK. I need to create a macro that will look at the values in these columns and enter the date 12/31/2099 in column EK if EB <> null and EK = Null.
For example,
if EB3 = 6/26/2017 and EK3 = "", enter 12/31/2099 in EK3, otherwise leave EK3 as it is.
if EB4 = "" and EK4 = "", do nothing.
if EB5 = "" and EK5 = 8/29/2021, do nothing.
There are no answers yet.
Be the first to answer this question.
Be the first to answer this question.