列幅と行高をコピーする
 サンプルマクロは、A1:D10のセル範囲の列幅と行高をE11から始まる
セル範囲にコピーします。

Sub Sample()

    Dim myBaseRng As Range, myNewRng As Range
    Dim myRow As Long, myClm As Long

    Set myBaseRng = Range("A1:D10")
    Set myNewRng = Range("E11")

    With myBaseRng
        For myClm = 1 To .Columns.Count
            myNewRng.Columns(myClm).ColumnWidth _
                = .Columns(myClm).ColumnWidth
        Next
        For myRow = 1 To .Rows.Count
            myNewRng.Rows(myRow).RowHeight _
                = .Rows(myRow).RowHeight
        Next
    End With

End Sub

Excel95/97/2000



戻る


Excel Word Access VBA! モーグ