Help required, I need to change cell address dynamically by adding number of rows. For example, if the user enter 10 as a value, I need to add 10 rows to address B5 to make it as B15. I need to have this in the my named range formula so that the length of my named range is decided on the input given by the user. Hope I'm able to explain the scenario.