Solved: What's the difference?

[brunces]

Friends,

Please, tell me, what's the difference between...

Sheets("Sheet1").Cells(1, 1).Select and Worksheets("Sheet1").Range("A1").Select ???

Which is better to use? Are there specific cases we should use one or other?

Thanks for your attention. :)

Brunces

[mikerickson]

Sheets("Sheet1") vs. Worksheets("Sheet1")
The Sheets collection includes both worksheets (cells) and chart sheets.
The Worksheets collection does not include chart sheets.
Sheets.Count >= Worksheets.Count
If you don't use charts, Sheets is shorter to type.


Range("a1") vs. Cells(1,1)
Range is good for when I don't remember wheter M is 13th letter or the 14th.
For looping, Cells is better (IMO). I find it easier to read

Cells(rowNumber,13)
than

Range("M" & row)

The two argument Range is very useful

Range(Range("a1"),Range("b2")) = Range("a1:b2")

Does that help?

[brunces]

Yup! Thank you very much, mikerickson. :)

[lucas]

That does help mikerickson. Concise and easy to understand