Cannot Expand Named Range - when size of the Range exceeds

Hi

I've an excel sheet which contains a number of Named Range. I need to
add a number of records in each range. I'm using VB.NET and ODBC to add
rows.

It adds records properly when the number of records are inside the
Named Range. But when the number exceeds - it generates error "Cannot
Expand Named Range". I don't know how many number of rows to be added
in each range - so I cannot preset the size of the range.

What is the work-around?

Thanks...
Snig.

You have a response in .misc

Snig wrote:
>
> Hi
>
> I've an excel sheet which contains a number of Named Range. I need to
> add a number of records in each range. I'm using VB.NET and ODBC to add
> rows.
>
> It adds records properly when the number of records are inside the
> Named Range. But when the number exceeds - it generates error "Cannot
> Expand Named Range". I don't know how many number of rows to be added
> in each range - so I cannot preset the size of the range.
>
> What is the work-around?
>
> Thanks...
> Snig.

--

Dave Peterson