• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Cell Address


New Member
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.