'----------------------------------------------------------------------------- Public Sub morning2013_9_12(Workbook_Or_Worksheet As Variant) Dim wkTgt As Object, wkTgType As Byte, i() As Long
On Error GoTo Err_Get
wkTgType = 0
Select Case TypeName(Workbook_Or_Worksheet) Case "Workbook", "Worksheet"
ReDim i(1)
i(1) = 1 wkTgType = 2 Set wkTgt = Workbook_Or_Worksheet
If TypeName(Workbook_Or_Worksheet) = "Workbook" Then wkTgType = 1 i(1) = wkTgt.Worksheets.Count End If
Case Else
MsgBox "渡し値が無効です。ターゲットの判定ができません。処理は失敗しました。", , "【" & ThisWorkbook.Name & "】" Exit Sub
End Select
If wkTgType = 1 Then
For i(0) = 1 To i(1)
wkTgt.Worksheets(i(0)).Cells.Clear
Next
Else
wkTgt.Cells.Clear
End If
Set wkTgt = Nothing ReDim i(0)
Exit Sub Err_Get:
Debug.Print Err.Number & " " & Err.Description Resume Next
End Sub '-----------------------------------------------------------------------------