Can I do this without populating worksheet cells with the Average and
Standard Deviation directly in VBA?

Yes.

Dim dX As Double
dX = Application.WorksheetFunction.Average(Sheets("Shee t1").Range("A1:A2"))

HTH,
Merjet