Hi.
I need to protect and make some input sheets for users fool proof.
For instance, the macro I have written refers to dynamic ranges where user will list data to be used in the macro.
What would be the best way of notifying the user to not leave any blanks when putting the data in, as the dynamic range won't pick them up. And no, I don't want to alter the dynamic range to being the other style.
RET79
I need to protect and make some input sheets for users fool proof.
For instance, the macro I have written refers to dynamic ranges where user will list data to be used in the macro.
What would be the best way of notifying the user to not leave any blanks when putting the data in, as the dynamic range won't pick them up. And no, I don't want to alter the dynamic range to being the other style.
RET79