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?

 

[Tom Ogilvy]

the text property will contain #

 

[SIGE]

Hi Norman,

I am not sure how to turn that on?

Sige

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

 

[SIGE]

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

Thanks Tom

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

 

[Gary Keramidas]

just use

columns("a:z").autofit

for example