Var Formula With Range Based On Counter

I have a macro that I am working on that, I hope, will calculate the variance in my worksheet. The issue is, I am removing the outliers from my formula, so I need to loop through a range counting the "non-outliers." When the loop is complete I will know the last cell needed for my range. How would I take that variable and turn it into a range, similar to this: "A2:a(count)"

Here is what I have currently

***************
Dim cell As Range
Dim count As Integer
Dim var As Long
var = 0
count = 0

[code]....