Too narrow columns
 

Hi There,

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

Brgds Sige

Too narrow columns
 

Hi Sige,

Why not autofit any potentially contentious columns?

---
Regards,
Norman



"Sige" wrote in message
oups.com...
Hi There,

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

Brgds Sige

Too narrow columns
 

the text property will contain #

--
Regards,
Tom Ogilvy


"Sige" wrote in message
oups.com...
Hi There,

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

Brgds Sige

Too narrow columns
 

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 ***

Too narrow columns
 

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 ***

Too narrow columns
 

just use

columns("a:z").autofit

for example
--


Gary


"SIGE" wrote in message
...
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 ***