Excel VBA: AutoFill

'kopyalanacak formulun bulundugu hucre
Dim f As String
f = "B1"

'formulun kopyalanacagi alan
Dim r As String
r = "B1:B10"


Range(f).AutoFill Range(r)