| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I refer a Range to a Cell | Excel Worksheet Functions | |||
| sumif range of varying size | Excel Worksheet Functions | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| How do you change the size of a range of cells in a column/row | Charts and Charting in Excel | |||
| Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions | |||
Linear Mode
