Setting a column to Text datatype

I'm sure this is deathly simple but for whatever reason, I can't seem
to discover (either on my own or through other Google posts) how to set
an entire column to the Text datatype through VB6.
Any help would be appreciated.

one way:

ActiveSheet.Columns(1).Cells.NumberFormat = "@"


In article <[email protected]>,
[email protected] wrote:

> I'm sure this is deathly simple but for whatever reason, I can't seem
> to discover (either on my own or through other Google posts) how to set
> an entire column to the Text datatype through VB6.
> Any help would be appreciated.