don't understand why you need to link anything

The most important thing in computer programming is "Loop".  Humans hate repetative work and computers love them.  As long as you can do loop, you are fine.

Private Sub test1()

    Dim ws As Worksheet

    For Each ws In ThisWorkbook.Worksheets

        Debug.Print ws.Name

        'Insert your code here

    Next ws

End Sub

所有跟帖： 

• Sorry I don't know how to write code, is this the code for macro -n700- ♀ (0 bytes) () 09/24/2012 postreply 15:10:30

• VBA很容易学 -slow_quick- ♂ (0 bytes) () 09/24/2012 postreply 15:54:43