I have a designer file where the range is already defined for a cell.
Now I need to...
1. access the cell by the range name and put data into the cells.
2. extend the range appropriately if more cells need to be included.
3. access the address (row and column) of the range.
Please let me know how to implement this scenario