Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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).
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,522
Default 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).


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing Excel report into Word showing headers and footers LossManiac Excel Discussion (Misc queries) 1 August 29th 08 01:56 PM
How to remove an external data source Dinesh New Users to Excel 1 August 22nd 08 08:31 PM
Importing External Data Donbenz1 Excel Discussion (Misc queries) 0 June 14th 07 09:36 PM
Remove Headers Hilton Excel Discussion (Misc queries) 4 May 3rd 07 01:15 PM
Importing External Data Paul Hammond Excel Discussion (Misc queries) 0 December 15th 05 10:28 PM


All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"