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