複数のセル範囲を正規化します。
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 件のコメント:
コメントを投稿