I will admit I was a little confused initially upon reading that as I have not encountered that specific problem at all (Or any other).
I have been testing the sheet relentlessly in every (albeit limited) way(s) I know how and have not encountered the problem you so kindly illustrated.
The...
Upon frequent testing it works perfectly. Absolutely as intended! I am amazed to how it functions so well with so much less code.
It's just sort of a quick visual reference for comparing dates for the user rather than having to glance down at the calendar, it's not really necessary. But thanks...
I have no idea how to do this and any assistance would be greatly appreciated. Ah, so the moving of the cells is what caused the REF! and the format errors, good to know!
The idea is is that the date should freeze whenever information arrives onto the sheet. Almost like some sort of...
Hello again Hui! I've managed to fix the sheet by cheating a little (Recorded Macros) But now it is fully functional. Thanks a bunch for your help! Hope this helps someone who is in the same situation. Here's the adapted code and the modules that reset things:
Edit: After an hour or so of bug...
Thanks! Works flawlessly, except that the freeze date formula (=IF(B20<>"",IF(H20="",NOW(),H20),"")) outputs as #REF! and I'm not entirely sure as to why. After checking https://support.office.com/en-gb/article/How-to-correct-a-REF-error-822c8e46-e610-4d02-bf29-ec4b8c5ff4be
it appears to be due...
The following code seems to function perfectly, although results in an Error 13: Type mismatch. Could anyone advise on where the data types conflict?
Sub delete_old()
Dim rowDate
Dim curDate
Dim interval
Dim curAdd
Dim vCell As Range
' set interval to an appropriate...
Additionally, there is another formula on the worksheet that is not functioning (Possibly due to the same error with the initial formula) which can be found in Sheet3(FinishedJob). This formula is intended to regulate (Delete) information based on current date vs date inputted. I have managed to...
Hello there! Firstly, I am not Excel proficient nor entirely VBA literate and although I have progressed thus far, I am unable to complete the sheet. Any assistance would be appreciated. Apologies in advance for any misuse of terminology or coding language. I hope I can provide you with enough...