View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BriLar1 BriLar1 is offline
external usenet poster
 
Posts: 1
Default Remove Columns with header in row 1 but no data in remainder of co

How do I Remove Columns with header in row 1 but no data in remainder of
column?
I am using exported template spreadsheets that provide the header row ready
for data import to the spreadsheet then using this to do bulk import to SQL
database, but need to remove the blank columns were there is no data below
the header en mass. Can anyone give me tips on how this could be done either
using vb code or macros.
Thanking you in advance