How to use filldown with variables

[stephicohu]

What I am doing is to fill down the equation on AG3. What I want to do is to fill down 4 rows to AG7. I wan to use variables because I have many equations in different columns to down fill. The code is below:

Sub Test2()

Dim Sumnum As Integer
Dim Num1 As Integer
Dim BottomNum As Integer

Sumnum = 0
Num1 = 0
BottomNum = 0

Sumnum = 33
Num1 = 3
BottomNum = 7

Range(Cells(Sumnum, 3), Cells(Sumnum, 7)).FillDown



Range("V25").Select

End Sub

What am I doing wrong?

Thanks....

Stephanie

 

[Fluff]

How about

Range(Cells(Num1, Sumnum), Cells(BottomNum, Sumnum)).FillDown

 

[Alex Blakenburg]

Fluff has already provided the fix. Just some background. The syntax is:
Range(Cells(FirstRow, ColNo), Cells(LastRow, ColNo)).FillDown
If you actually use the words Row & Col as part of the variable names you are far less likely to get confused.

 

[stephicohu]

Fluff has already provided the fix. Just some background. The syntax is:
Range(Cells(FirstRow, ColNo), Cells(LastRow, ColNo)).FillDown
If you actually use the words Row & Col as part of the variable names you are far less likely to get confused.

That is correct.... I found the problem at 1:00 am PST this morning. I'd reversed the row and col. I am doing that now using row and column in the variable.

Thanks

Stephanie....

 

[Fluff]

Glad we could help & thanks for the feedback.