I have a cell which keeps track of the number of rows on a worksheet.
(The number of rows varies).
I want to be able to use this variable number when creating a range
name, and populating this range by pasting into the 500 cells in one
column, a formula from a master cell.
i.e. suppose the number of rows on the worksheet is 500, from
A10:Z509, a master formula in cell F1, and the row count cell called
Myrows which evaluates as 500.
I need some VBA code to create a range name which covers say F10:F509
(the F10 will always be the first cell), and then copy the formula in
F1 into the range F10:F509
I'd be grateful for any help. I'm still fairly new to VBA and still
feeling my way.