Too narrow columns

[Sige]

Hi There,

How can I find (&Select)columns on my worksheet which are too narrow?
(#####)

Brgds Sige

[Norman Jones]

Hi Sige,

Why not autofit any potentially contentious columns?

---
Regards,
Norman



"Sige" <[email protected]> wrote in message
news:[email protected]...
> Hi There,
>
> How can I find (&Select)columns on my worksheet which are too narrow?
> (#####)
>
> Brgds Sige
>

[Tom Ogilvy]

the text property will contain #

--
Regards,
Tom Ogilvy


"Sige" <[email protected]> wrote in message
news:[email protected]...
> Hi There,
>
> How can I find (&Select)columns on my worksheet which are too narrow?
> (#####)
>
> Brgds Sige
>

[SIGE]

Hi Norman,

I am not sure how to turn that on?

Sige

"NOSPAM" to be removed for direct mailing...

*** Sent via Developersdex http://www.developersdex.com ***

[SIGE]

If IsNumeric(Cel.Value) And Left(Cel.Text, 1) = "#" Then

Thanks Tom

"NOSPAM" to be removed for direct mailing...

*** Sent via Developersdex http://www.developersdex.com ***

[Gary Keramidas]

just use

columns("a:z").autofit

for example
--


Gary


"SIGE" <[email protected]> wrote in message
news:[email protected]...
> Hi Norman,
>
> I am not sure how to turn that on?
>
> Sige
>
> "NOSPAM" to be removed for direct mailing...
>
> *** Sent via Developersdex http://www.developersdex.com ***