Re: Algorithm / Assign Max Value
Couple of different ways to evaluate for blank cells.
For one one I wouldn't ever use "". Instead use the keyword vbnullstring.
Alternatively you couod check the actual actual length of the contents of the field.
So something like:
I believe checking the length of the field is more efficient that actual trying to evaluate the field itself.
You basically need to rewrite the function function to deal with the blanks or evaluate the blanks using a different function/method.
Tge current function only handles the cell having some contents.