Insert Cells In Range - Increase Named Range

I have a spreadsheet that has one cell that is a named range. I know how to access this cell with:

curRange(0, 0).PutValue(value) - if I want to put a value there.

How do I increase the range to the next row (not insert a whole row, but just put data into the next row's cell), and then increase the range to include the new cell.

If I put data into B2, for example, and the named range is only on B2, I want to add data into B3, and increase the range to include B3.

Is this possible?

Hi,

I think you may try to re-create the range for your desired crietera if it suits your need:

e.g..,

Workbook workbook = new Workbook();
workbook.Open("f:\\test\\RangeExtension.xls");
Names names = workbook.Worksheets.Names;
Name name = names["MyRange"];
Range range = workbook.Worksheets[0].Cells.CreateRange("B2", "B3");
range.Name = name.Text;

Thank you.