Using VBA I need to paste a named formula “BinTest” into a range of cells in a column. Starting at A37. The length of the range of cells is dependant upon the value of another name “Range”. I want this to fire when the worksheet is selected if that is possible.

I think I need to use a fill function and somehow check the value of “Range” and then say fill down from A37 but I have no idea where to start.

Any help, code examples, etc. will be appreciated

Robert