I assigned a name to cell A10 and ran this code:

Rows(5).Delete

After that the name referred to A9. Looks okay here.

--
Jim
"J Streger" wrote in message
...
|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
|