Allowing macro to run only when ALL selected cells are withing a range.

Currently I am trying to run a program on when all the selected cells are withing a certain range. Using Intersect(ActiveCell, Range) works but you can select as many cells as you want that are not in the range and the program will still run as long as the activecell is in the range. Using Selection instead of ActiveCell will run as long as one of the selections is in the range.

What I am trying to accomplish is to be able to select as many cells as I want inside the range and have the program run on these cells. If runs a formatting program utilizing cell offsets from the range.

An example of this code is:

Please Login or Register  to view this content.

Which would call something like:

Please Login or Register  to view this content.

Ok so it looks like I have to compare to see if all are within the selection. Its amazing how something so simple starts to blow up just from one little issue.

Thank you for the super quick reply also. You must have not had to think at all how to figure this out this out.