As part of a Sub, I have the following code that I want to use to fill down
worksheet formulas. Ive defined integer variables for totalRows, lastRow and
lastFilledRow in a defined range, €�StocksFormlas.€� The defined range is
(€œF8:O40€�). Ive also defined a €œy€� variable as Range.
At last run, the returned values for the integer variables are
TotalRows = 33
lastFilledtRow = 14

The first line of code snippet (1), below selects €œF14€�. The second line
does the fillDown correctly, but only if I specify the fillDown arguments in
€œA1€� form. Ive tried everything I know to accomplish the fillDown using
variables to represent the arguments, so that when the address of the last
filledRow changes it can be used as the first argument of the fillDown
method.

Snippet (2) below obviously doesnt work but represents an alternative
approach Ive tried, to no avail. Can someone help me with this? Im growing
old trying to solve this problem.
Thanks very much

(1)
Range("StocksFormulas").End(xlDown).Select
Range("F14:O30").FillDown
(2)
Range("F" & myLastFilledFormulaRow).Select
Set y = Selection
Range("y", Range("O20")).FillDown