Too narrow columns

Hi There,

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

Brgds Sige

Hi Sige,

Why not autofit any potentially contentious columns?

---
Regards,
Norman



"Sige" <SIGE_GOEVAERTS@HOTMAIL.COM> wrote in message
news:1129123987.611201.291160@f14g2000cwb.googlegroups.com...
> Hi There,
>
> How can I find (&Select)columns on my worksheet which are too narrow?
> (#####)
>
> Brgds 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 ***

just use

columns("a:z").autofit

for example
--


Gary


"SIGE" <sige_goevaerts@NOSPAMhotmail.com> wrote in message
news:u2XoP2zzFHA.3540@TK2MSFTNGP10.phx.gbl...
> 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 ***

the text property will contain #

--
Regards,
Tom Ogilvy


"Sige" <SIGE_GOEVAERTS@HOTMAIL.COM> wrote in message
news:1129123987.611201.291160@f14g2000cwb.googlegroups.com...
> Hi There,
>
> How can I find (&Select)columns on my worksheet which are too narrow?
> (#####)
>
> Brgds 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 ***