Range("C1").Value = "the length you want the column"
Columns("C:C").Autofit

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"confused" wrote in message
...
anyone????

"confused" wrote:

i don't understand, can you do a format cell thing? do you have to
change the
font?

"Marcelo" wrote:

hi

format the font as courier and type how many caracters you need width

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"confused" escreveu:

Format column to be x characters wide.