Setting column width if #### appears in column
Danke. Merci. Gracias. Thank you.
"Tom Ogilvy" wrote in message
...
for each cell in Range("A2:Z2")
if instr(1,cell.Text,"###",vbTextCompare) then
cell.EntireColumn.Autofit
end if
Next
--
Regards,
Tom Ogilvy
"qwerty" wrote in message
...
If a column is not wide enough for the displayed number, it shows #
signs.
In VBA is there a way to detect which cells in which columns have that
###
so I can use column autofit to set to the width needed?
|