Tema: VBA: kaip optimaliausia?
Autorius: Gedas
Data: 2009-04-19 07:29:29
Va toks klausimas:
1. With Worksheets("bla")
        .Range("A1", .Range("A1").End(xlDown)).Activate
    End With

2. With Worksheets("bla")
        Range(.Range("A1"), .Range("A1").End(xlDown)).Activate
    End With

3. With Worksheets("bla").Range("A1")
        Range(.Offset(), .End(xlDown)).Activate
    End With

4. With Worksheets("bla").Range("A1")
        .Range(.Offset(), .End(xlDown)).Activate
    End With

Kuri is konstrukciju optimaliausia?
P.S. Atkreipkit demesi i taskus