The code I gave, does not delete any rows.
Unless you have defined names to those cells the effect is exactly same
as clearing the cell and manually doing cut-paste to move up.

Sharad



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!