Range.
 

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

Range.
 

Look at Areas.Count

Mike F
"Heera" wrote in message
...
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

Range.
 

Try this

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

"Heera" wrote:

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

Range.
 

Thank you Joel