IF??? you mean a shape
for each sh in activesheet.shapes
sh.cut
next sh

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"e-Learning" wrote in message
...
I am combining several worksheets into a summary document. When I import
external data, the headers for each worksheet remain. These are the
headers
that CANNOT be removed (the ones with the boxes with arrows).