use variable value in a range reference?

  • Thread starter Thread starter JCIrish
  • Start date Start date
J

JCIrish

My code is

Dim myformulaTotalRows As Integer
Dim mylastFormulaRow As Integer

With Range("formulaCells") 'named range
totalRows = .Rows.Count
lastRow = .Rows(totalRows).Row
End With

myformulaTotalRows = totalRows
mylastFormulaRow = lastRow

Is there a way to use "mylastFormulaRow" in a statement like
Range("C6").select where the row number 6 can be replaced by
"mylastFormulaRow"?

I want to use the selected cell as the first argument in a .filldown statement

Thanks for any help
 
Sub fillitdown()
'Range("e1").AutoFill Range("e1:e4")
dim lr as long
lr = Cells(Rows.Count, "e").End(xlUp).Row
Cells(lr, "e").AutoFill Cells(lr, "e").Resize(4)
End Sub
 
Thanks, Dave. I must have tried ten things similar to your solution except
including the &. I appreciate the help.
 
Thank you,Don. That's a more elegant way to go than my Sub. I'm sure it will
be useful to me in many similar situations.
 
Back
Top