colum width
 

Format column to be x characters wide.

colum width
 

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.

colum width
 

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.

colum width
 

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.

colum width
 

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.

colum width
 

What's the question? How do you adjust the column width?

If so, highlight the column in question by clicking the identifier at
the top of the column, then Format | Column | Width - you will be
presented with a panel where you can type the width directly. However,
the font size you choose will allow you to have more or fewer
characters within that width.

I'm confused about what you want, but I hope this helps.

Pete

confused wrote:
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.