複数のセル範囲を正規化します。
Public Function NormalizeRange(Ranges As Range) As Range
Dim Retval As Range
Dim i As Long
If Not Ranges Is Nothing Then
Set Retval = Ranges.Areas(1)
For i = 2 To Ranges.Areas.Count Step 1
Set Retval = Application.Union(Retval, Ranges.Areas(i))
Next
End If
Set NormalizeRange = Retval
End Function
0 件のコメント:
コメントを投稿