| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 and Named Ranges
I encountered a problem in 2007 which I believe is a bug. Just wondering if
this is a known issue or not. When we programatically delete a row using rows(X).entirerow.delete we noticed that in 2007, that a named range that was a row beneath the deleted row did not shift up. In 2003 and with insert in both editions and going through the Excel UI, named ranges shifted when rows were inserted/deleted, just programatically deleting rows/columns did not shift the named ranges. Am I missing something or is this a bug? -- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003 User of MS Office 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Named Ranges | Excel Discussion (Misc queries) | |||
| How do I set up a Dynamic Named Ranges in Excel 2007 | Excel Discussion (Misc queries) | |||
| Named Ranges Disappearing in Excel 2007 | Excel Discussion (Misc queries) | |||
| Named ranges in Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 Beta-Named Ranges | Excel Discussion (Misc queries) | |||
Threaded Mode
