Range.

  • Thread starter Thread starter Heera
  • Start date Start date
H

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
 
Try this

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