データの最期を調べる
Range("A1").Select
Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
rend = Selection.Rows.Count
Range("A2").Select
Range(Selection, Selection.End(xlDown)).Select
epoint = CStr(Selection.Rows.Count + 1)
MsgBox ("計上組織~PJコード列にて、全行にデータを付与します。")
Range("AS2:AV2").Select
Selection.AutoFill Destination:=Range("AS2:AV" + epoint), Type:=xlFillDefault
Range("AS1").Select