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