Modify

count = Evaluate("SUM(ROW(1:" & nVariable & "))")
the above does not write to the worksheet in any way - it's a simple means of calculating what you want without need for iteration.