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