How to remove headers when importing from an external source?
 

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).

How to remove headers when importing from an external source?
 

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).