Test for "if selection includes cells outside range"

**phenomenix** · 08-01-2008, 03:24 PM

Using Excel 2003 I need an If statement to test if the current selection by the user includes cells outside a given range.

In this example let's say my range is range("A1:E10")

My code should be able to say something like:

If [current selection includes cells outside of range("A1:E10")] then
msgbox ("Sorry but this feature is not available for the cells you selected.")
End If

Can anyone suggest a way to do that?

Thank you so much!!

Roger

**shg** · 08-01-2008, 03:52 PM

Maybe like this.

    Const sAdrs As String = "A1:E10"
    
    If Union(Selection.Cells, Range(sAdrs)).Address(0, 0) <> sAdrs Then
        MsgBox ("Sorry ...")

**phenomenix** · 08-01-2008, 04:12 PM

Your code worked like a champ. Thank you so much.

I sometimes feel guilty that I don't have a practical way to thank a person for help like this.

Best wishes,

Roger