I have created a dynamic named range using the offset function, but now I want to fill that range with a formula, so that if the dynamic named range consist of 20 cells, the 20 cells will have the formula, and if I change the number of cells to 1000, the 1000 cells would have the formula. Is it possible to do this without using VBA?

Thank you.