Hello,

I would like to make a macro (Workbook_SheetChange) to display an error message if the value entered is not within a range of 1000000 and 3999999.
I already have code to display error message if the entered value already exists in the worksheet

How can I set this up?