excluding text entries in calculations
I have the template with macros doing calculations. It is working fine but
when users will enter space which is not visible to correct it is giving
errors and I have to find out where users entered them. They may enter one or
few spaces. What I am looking for is to exclude in calculations those cells
which do not have values but spaces. Is it possible to do that ? How ?
Thanks for help.
Tony
|