>Hi All,
>
> I came across a problem today when importing from an Excel file that had a hidden column. When I imported the file the column headings were the same as the Excel column headings but the field contents were different. I selected the entire spreadsheet in Excel and made all columns unhidden. The import then worked find. Hope someone finds this useful.
>
>Gavin...
Ok, this would work
Selection.EntireColumn.Hidden = False
If it's not broken, fix it until it is.
My Blog