Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to reference variable range? | Excel Discussion (Misc queries) | |||
Use variable to reference a range? | Excel Programming | |||
How do I set up a variable reference range in Excel? | Excel Programming | |||
Variable range reference | Excel Discussion (Misc queries) | |||
Variable Range Reference | Excel Programming |