Automating Formating Columns using VBA

[drj]

Hi

I need to import an excel file to ms access but keep getting errors because the field type varies between ms access and excel and I wanted to use vba to automatically change the column format on my excel sheet depending on a value of a cell.

From A1 to Z1 on my Excel Sheet there is a value of either T for "Text" which means if a cell has a T then the whole column should be formatted as text and if the cell has a N for "Number" then the whole column should be formatted as Number.

This is what I had in mind:

If cell e.g. A1 = "T" then format column as Text but if cell = "N" then format column as number.

Hope it makes sence.
Thanks in advance.

drj

[VBA Noob]

Something like

Please Login or Register  to view this content.

VBA Noob