If the cell value is within a number group then display a message

[JOAO12]

Hello everybody,

I need a macro that checks if the the value of a cell is within a group of numbers and, if so, displays a message.

The following code is not working.

Please Login or Register  to view this content.

Any help is welcome.

Thanks,

John

[MaczaQ]

maybe this way ?

Please Login or Register  to view this content.

[JOAO12]

Hi MaczaQ,

It worked fine. Thank you.

Could you please check why the following code did not work fine too? In fact, instead of displaying a message, I need to copy a range and paste it at another sheet, called "1 + 1 + 1 + 1 + 1". Could you please correct it?

Please Login or Register  to view this content.

Thank you again,

John