MsgBox if the Active Cell is not within a preferred Range

**Winon** · 12-03-2011, 04:28 AM

Hi to all,

I am missing something somewhere. I want to show a MsgBox if the Active Cell is not within a preferred Range. Tried various If statements using if Active Cell is smaller than the preferred range, but nothing wants to work.

Any ideas anyone?

**john55** · 12-03-2011, 04:47 AM

hi,
see if it helps you
http://www.exceltip.com/st/Determine...Excel/484.html

Please Login or Register  to view this content.

**Winon** · 12-03-2011, 05:19 AM

Thank you john55,

I shall give it a bash and let you know !

**Winon** · 12-03-2011, 05:48 AM

john55,

As promised. Report Back Time. It works like a charm.

THANK YOU!

**john55** · 12-03-2011, 05:52 AM

glad it helped

If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.