列の非表示 |
Rows( "1:" & CInt (InputRow)). Select
Selection.EntireRow.Hidden = False
|
|
列の非表示解除 |
MaxColumn = Cells(1, Columns.Count). End (xlToLeft).Column
Range(Columns(1), Columns(MaxColumn)). Select
Selection.EntireColumn.Hidden = true
|
|
行の非表示 |
Columns( "A:F" ). Select
Selection.EntireColumn.Hidden = False
|
|
行の非表示解除 |
RowMax = Cells(Rows.Count, 1). End (xlUp).Row
Rows( "1:" & RowMax). Select
Selection.EntireRow.Hidden = False
|
|
最大行番号の取得 |
MaxRow = Cells(Rows.Count, 1). End (xlUp).Row
|
|
Lmax = Range( "A1" ). End (xlDown).Row
|
|
最大列番号の取得 |
MaxColumn = Cells(1, Columns.Count). End (xlToLeft).Column
|
|
MaxColumn = Range( "A1" ). End (xlToRight).Column
|
|
行のコピー |
Rows( "1:1" ). Select
Selection.Copy
Sheets( "工種未入力" ). Select
Rows( "1:1" ). Select
ActiveSheet.Paste
|
|
列の追加 |
Columns( "P:P" ). Select
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
|
|
行の追加 |
Rows(LoopCnt). Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
|
|
重複行の削除 |
ActiveSheet.Range( "$A$1" , "$B$" & Lmax).RemoveDuplicates Columns:=2, Header:=xlYes
|
|
行のグループ化 |
Range( "A" & GLevel8_Start, "M" & GLevel8_End). Select
Selection.Rows.Group
|
|
列の削除 |
Columns( "A:C" ). Select
Selection.Delete Shift:=xlToLeft
|
|
行の削除 |
Rows( CInt (Delete_MaxRow + 1) & ":" & MaxRow_S). Select
Selection.Delete Shift:=xlUp
|
|
列幅設定 |
Columns( "A" ).ColumnWidth = 13
Range(Columns(3),Columns(5)).ColumnWidth = 20
Rows(1).ColumnWidth=10
|
|
行の高さ |
Rows(10).RowHeight = 15
Range(Rows(15), Rows(18)).RowHeight = 10
Columns(1).RowHeight=15
|
|