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.
Dynamic Cell Address
- Thread starter Gurbir
- Start date
pecoflyer
Well-Known Member
Which is your named range formula? Are you using the ADDRESS function, INDEX, INDIRECT, to define the cell address?
A sample file as advised in this forum's recommendations will help
A sample file as advised in this forum's recommendations will help
I am using INDEX.