Range.

[Heera]

Hi,

If a user select's a range say A1:A10 then the macro should run.

But if a user select's multipul range say A1:A5 & A8:A10 then it
should give a msgbox.

My intension that the user should only select the range which is in
sequenc......

I tried to work with ActiveWindow.RangeSelection.Address but could not
find a way to find out a way.

Regards
Heera

 

[Mike Fogleman]

Look at Areas.Count

Mike F

 

[Joel]

Try this

Set MyRange = Selection
If MyRange.Areas.Count > 1 Then
MsgBox ("Move thean one area selected")
End If

 

[Heera]

Thank you Joel