How would one go about checking the result of a worksheet formula with VBA?
I have a sheet that uses the MIN function to check the first entry date and the MAX function to check the last entry date on the sheet. Of course, if there is no entries yet, the cell with the function populates with "1/0/1900". That is not horrible, but I like to tidy things up like that and in the process of writing some VBA to do all of the work, I wanted to try and see if I could clean that up.
My thought was to have VBA check the MIN function and if it was returning "1/0/1900" then populate the cell with something along the lines of "No Entries". I am currently using =IF(Register[Date]="","No Entries",MIN(Register[Date])) which of course works. However, I wanted to use VBA (not only to see if I can do so but just to learn more too) to check if the MIN function returns anything (specifically 1/0/1900) and if that is true then populate the cell with "No Entries", else run the MIN function.
Hopefully I explained that well enough. If that can be done, how would one go about doing so?
Bookmarks