named foumula "BinTest":
=IF(COUNT(BINFilStart:A)<INDIRECT($C$114&"BinCount "&$D$114),A113+INDIRECT($C$114&"BinSize"&$D$114)," ")

Thanks
Robert

Sandy wrote:
What is the formula for "BinTest"?

wrote:
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