|
Sub yyuu()
On Error Resume Next
Dim SHT As Worksheet, STRN$, n%,arr
STRN = ""
For Each SHT In Worksheets
If SHT.Name <> "" Then
STRN = STRN & SHT.Name & ","
End If
Next
If len(STRN)〉1 Then arr = Sheets(Split(Left(STRN, Len(STRN) - 1), ",")).Range("A1")
Set SHT = Nothing
End Sub |
|