Sub abcd()
Dim obj
Set NewSheet = Worksheets.Add
i = 2
NewSheet.Range("A1").Value = "Name"
NewSheet.Range("B1").Value = "Link Type"
Sheet1.Select
For Each obj In Worksheets("Sheet1").OLEObjects
NewSheet.Cells(i, 1).Value = obj.Name
If obj.OLEType = xlOLELink Then
NewSheet.Cells(i, 2) = "Linked"
Else
NewSheet.Cells(i, 2) = "Embedded"
End If
i = i + 1
Next
End Sub
为什么当我运行到 For Each obj In Worksheets("Sheet1").OLEObjects 这里的时候就直接跳到end sub 了,这是什么原因