Hi,
how do I ensure within a range of cells in a worksheet only a unique value can be entered even when pasting into the cell. The data validation function works well for this if the data is typed in but not pasted. Is there a VBA function that I can use?
your help will be greatly appreciated
how do I ensure within a range of cells in a worksheet only a unique value can be entered even when pasting into the cell. The data validation function works well for this if the data is typed in but not pasted. Is there a VBA function that I can use?
your help will be greatly appreciated