From: e-Learning on
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).
From: Don Guillett on
IF??? you mean a shape
for each sh in activesheet.shapes
sh.cut
next sh

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"e-Learning" <e-Learning(a)discussions.microsoft.com> wrote in message
news:5AF1C30A-E576-41ED-ADFB-D1E17184EA7E(a)microsoft.com...
>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).