View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JCIrish JCIrish is offline
external usenet poster
 
Posts: 39
Default use variable value in a range reference?

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