With Or Without

[billandrew]

Good afternoon

What are the advantages of utilizing the With Statement. Additional question How would an array be beneficial here?

Thank You

With -

lr = Range("B" & Rows.Count).End(xlUp).Row

For i = 2 To lr

With Sheet2

.Cells(i, "D").Value = Application.WorksheetFunction.Sum(.Range(Cells(i, "B"), Cells(i, "C")))
.Cells(i, "E").Value = Application.WorksheetFunction.Average(.Range(Cells(i, "B"), Cells(i, "C")))

End With

Next I

 

[Scott Huish]

It is allowing you to not specifically specify Sheet2 every time you need it.

Need more details about your array question.

 

[billandrew]

Thank You.

Would defining a range to an array I would assume it would be more efficient, however would it be practical. Learning about arrays in particular Dynamic Arrays.

 

[steve the fish]

You are missing a few periods. .Range and .Cells.

 

[billandrew]

Thank You