hi all,

Dave's suggestion is good in terms of preventing header deletion but is
still fallible in terms of a "by design" limitation of the specialcells
property (see 'here' (http://support.microsoft.com/kb/832293/en-us)).
Here's a link suggesting various workarounds (which you may need help
implementing...):

'Bulk Row Deletion - Fastest method in Excel Programming'
(http://tinyurl.com/nkm5fl)

hth
Rob


--
broro183

Rob Brockett. Always learning & the best way to learn is to
experience...
------------------------------------------------------------------------
broro183's Profile: http://www.thecodecage.com/forumz/member.php?userid=333
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=107832